Opening excel file directly is very slow

Anonymous
2013-02-26T12:25:10+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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
2013-03-02T00:50:36+00:00

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:

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

then SYSTEM

then CurrentControlSet

then Control

then Session Manager

then MemoryManagement ****then click PrefetchParameters

  1. On the right side, double-click on EnableSuperfetch
  2. 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+

Was this answer helpful?

100+ people found this answer helpful.
0 comments

84 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2015-09-11T22:50:08+00:00

    Try logging out of your Microsoft account on the machine and logging in "locally" instead. That solved it for me, but you do lose the Cortana functionality. 

    You can log out / log in by hitting start, right click your username on the left hand corner, select Change Account Settings, and from there you should be able to select "log in locally to this machine" or something to that effect.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-09-11T22:53:09+00:00

    I'm not logged into a Microsoft account.  I only log in locally.  Do not see the need to tell Microsoft every time I log into my computer at home.

    So sadly this is not a solution for me.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-09-13T15:36:38+00:00

    This worked for me as well, just changing it to the following worked for office Excel 365.

    "C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE" "%1"

    My EnableSuperfetch was already set to 3 and my PC was exhibiting all the same issues pointed out in the initial request.  Great Help for the suggested change to regedit that helped.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2015-09-22T21:25:50+00:00

    This is killing me.  My work environment has just been upgraded to Office Pro Plus with 365, which installed Office 2013 apps.  We have business critical spreadsheets that now take around 40 seconds to open.  Ironically, Office 2010 is left on th machines and if I open the same file in Excel 2010, opening time is less than 3 seconds.

    We are running Windows 7.  This many years on and still an open issue with no useful contribution that I can see from Microsoft people themselves.

    This is shocking!

    Just to quickly follow up on this.  None of the above mentioned fixes helped me at all, but I discovered the problem for me, and thought I would mention it here in case this might be the reason for others.

    http://dailydoseofexcel.com/archives/2015/04/07/excel-2013-vba-unreasonably-slow/

    My "business critical" workbooks have a lot of VBA and because they go to external clients, most sheets are protected.  The encryption in Office 2013 has been beefed up and protecting and unprotecting sheets massively increases the time and by default, I have code that automatically protects sheets on opening (just in case they were left unprotected last time), so may need to change this to protect the bare minimum rather than every sheet by default.  I proved this by copying my workbook and removing the sheet protection module, and it opens as fast as it does in 2010 now. (Though this is not a permanent solution)

    Was this answer helpful?

    0 comments