Opening excel file directly is very slow

Anonymous

I can open Excel directly and it launches immediately - not an issue.

I can launch Excel directly and then open a file - it opens the file immediately.

However if I open a file directly - without previously launching excel - it takes a long time - 30 to 40s.

I have tried many suggestions found online but none help. Does anyone have any ideas please?

Win 7 64 Bit

Office 2010

Thanks

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Solved.......I worked it out from searching the internet.

The issue is Superfetch. Mine was switched off.

As soon as it was turned on from Regedit followed by me starting it in Services - it works perfectly!

Here is the text from the solution....

I found this on Technipages website:

Mitch wrote:

"Superfetch caches data to RAM so that it can be immediately available to your application. Sometimes this can affect the performance of certain applications. It tends to not work well with gaming, but can improve performance with business apps.

To modify whether Superfetch is enabled or disabled, you can perform the following steps:

Click the Start orb and type REGEDIT in the Start Search area.
Open the Registry Editor.
Click the plus sign next to HKEY_LOCAL_MACHINE

then SYSTEM

then CurrentControlSet

then Control

then Session Manager

then MemoryManagement ****then click PrefetchParameters

On the right side, double-click on EnableSuperfetch
Give it one of the following values:

0 to disable Superfetch

1 to enable prefetching when program is launched

2 to enable boot prefetching

3 to enable prefectching of everything

Hit OK then Close RegEdit. "

Then goto the services MSC ("windows key + r" or just "windows key" and type services.msc). Scroll down to Superfetch and now should start. Click Start on the left info pane or double click it and change to automatic, then attempt to start again.

For informational purposes I chose the 4th option to enable prefetching for everything.

Hope this helps.

A.J. Silverman

MCSE+I, MCP, A+

0 comments

84 additional answers

Anonymous

2017-02-22T06:40:51+00:00

Life-saver! I got tired of this problem and finally landed on this solution. Thanks a million!
Was this answer helpful?

0 comments No comments
Anonymous

2017-01-18T13:26:56+00:00

thank you for this information. It worked well. I deleted excel in open with and re-defined excel and it worked.
Was this answer helpful?

0 comments No comments
Anonymous

2016-12-26T17:58:42+00:00

my issues with WIndows 10 may be related to Lenovo. This machine has never worked well with the Windows 10 power settings. I have always had issues with that. It ignores them or just does its own thing. It was going to sleep mode after 1 minute of inactivity and then it never goes to sleep mode. There have been many issues. Also the screen brightness is funky on this machine and has to be tinkered with. ANyway, with Excel, i will just open the application , then i can work with the files directly after doing that.. until the next time i start up.
Was this answer helpful?

0 comments No comments
Anonymous

2016-12-24T23:42:38+00:00

I think this is due to the fact that Microsoft so tightly integrates Office with the way Windows works. I have no idea what Excel is doing on start, but I can only assume it's executing some code via COM or DCOM that results in Windows going off to do something and Excel sits there waiting for control to return to Excel. Why they didn't put that on it's own thread and let it happen in the background, I don't know. Clearly, turning whatever it is off does not destroy the functionality of Excel, because I turned the offending thing off.

And I don't know exactly what I turned off, except to call it generically "Cortana". When you enable Cortana, there are several things Windows enables. Which one of those several things is it? I'm not sure and, like you, I don't want to waste my time trying to figure it out. I just turned off everything that was enabled when I enabled Cortana (following some instructions I found online and by also comparing settings on a different computer I have on my desk).

Other than this Excel issue, I've actually not had any problems with Windows 10. It's been pretty solid. I did, however, get pretty upset that Microsoft took it upon themselves to decide it was a good idea to reboot my machine automatically. I'm a software engineer who often works late and has a bunch of Windows open with code in them, often several to a Linux server where I do development. To come back to the computer in the morning to see it rebooted is more than frustrating. It takes a while to get everything back to the way it was so I can continue. It's not that it takes that long, but it's just the fact I have to spend a minute or two doing it, because Microsoft gave no consideration to my time. (Fortunately, I have Windows 10 Pro and there are ways to turn that off... and I did. Those with home versions are just screwed.)
Was this answer helpful?

0 comments No comments