Wednesday, April 16, 2008

Excel 2007 slow to open files

I think I am one of thousand people who upgrade MS Office to be MS Office 2007 and got pain for MS Excel to slow open file. It takes more than 1 minute. although there are no any add-in was installed and my file is only 333 KB.

1. Microsoft just blame to antivirus program. Hence, I disable my antivirus program and double click the excel file. It comes up faster as they said. Anyway, I still confuse that why the previous version can open faster although the antivirus program is enable and it is not good idea to switch off and on antivirus program every time when I want to open excel and will be crueler if I have to un-install the antivirus program for this matter.

2. Somebody told me to add more parameter %1 for all file type of Excel in the “OPEN” settings of Explorer file associations as follow.
- Launch “Windows Explorer”
- Click Menu Tools -> Folder Options
- Click Tab “File Types”
- Select item XLS in the list
- Click Button “Advanced”
- Select Open in the list
- Click button “Edit”
- Then add “%1” after /e in the box “Application used to perform action:”

but I found that it twice open the workbook when we double click on it.

3. I just install only one add-in, Lookup Wizard, to MS Excel. Amazing, my excel file can be open within 10 seconds when double click on it. So, I uninstall the Lookup Wizard add-in, close the Excel and re-open by double click the same file then it takes more than 1 minute for opening again. I do not know why just install an add-in can make MS Excel to fast open file as previous version.

Next experiment, I uninstall all Add-ins of Excel 2007 and install Add-in of Excel2003 (or previous version) then it take more than 1 minute to open file.

The last experiment, I create new file and save it as Add-in file of Excel2007 (Extension file is XLAM). There are not any data or VBA programing in the file. After I install the Add-in, I found that Excel can open file within 10 seconds.

HENCE, MY SOLUTION FOR THIS PROBLEM IS JUST INSTALL AN ADD-IN OF EXCEL 2007. You did not need to install all add-ins. Just install only one add-in and see the effect.

I hope that this solution will be useful and solve your problem. I will be appreciating if you can post some comment that is this solution work for you or not?

Thank you for your reading.

27 comments:

Anonymous said...

Thank you for researching this. Your solution worked fine for me.

Jeff Roughgarden
Ph.D., MCSD, MCDBA

zoom said...

Thank you for your comment and glad to hear that it is work for you too

Anonymous said...

It seems to be quicker. However, I still get the problem whereby when opening Excel by double-clicking on the xlsx file, I initially get a blank Excel screen - only by minimising Excel and then maximising again does the file actually open.

Anonymous said...

Finally. Leave it to Microsoft. I have looked high and low for a solution and this worked.

Anonymous said...

Awesome and weird too. It works. Thanks!!!

MadDog said...

In the options that you changed, remove the /e and leave only "%1"
This worked on many of my PCs and I had no need to do anything else

Anonymous said...

Thanks so much for this post. It worked :)

Anonymous said...

Totally strange. But it worked. Great job!

Anonymous said...

Many thanks for the easy solution - worked great

Anonymous said...

I have Adobe Writer and it has an Add-on in Excel. I went to: Program Files\Microsoft Office\Office 12\xlsstart\pdfmaker.xla and deleted the pdfmaker and the files open just fine now.

Anonymous said...

http://www.comtrick.com/index.php?gid=MsOffice&p=MsExcel2007SlowOpenFile

Mitch said...

Installing Add-on worked. Well done and thanks.

Had Office 2003 , unistaleld cleaned registry with RegSupreme Pro Installed 2007 Enterprise and had same issue.

The method for modifying the .xls file association did not work.

Anonymous said...

Yes, it does work. Quick and easy fix. Thanks!

Anonymous said...

Although his English was a bit difficult to follow, his solution fixed a problem that's been annoying me for months. I added "%1" to the end of the string for "Application used to perform action:" for both XLS and XLSX file types and now both types open faster than before. Thanks for the fix.

F. Alexander Bucci said...

I mjust tried your fix and it worked perfectly.

Thank you for doing the work to find a solution.

Mauro Mello said...

I've tried many solutions and finally I found one that works!
Thanks!

Anonymous said...

thanks it works faster now

Anonymous said...

Thanks for sharing your solution, it solved my problem!
Can't believe the old bug since 2008 is still haunting us :(

Anonymous said...

Thank you so much. It works! I apppreciate your help.

Anonymous said...

Your solotion not only work on excel & words, it also work on MS outlook attachment. Thanks.

james narvs said...

it works perfectly...thanks

rajesh said...

Thankyou so much zoom... it really worked... thanks for debuggong my problem.

Hariyatno said...

One of the ways to make Excel, and all MS office application is by UNCHECKING ask to update automatic links in option.
Open option and go to advance and go to GENERAL and uncheck :ask update automatic links.
I am sure it works, Just like what I did

Javed said...

great job dear thanks a ton

Anonymous said...

Thanks for this! My problem and solution was a little different. I have hyperlinks to webpages in Excel and there is serious lag until they open. I found that opening Access resolved the issue, even though there are no links to Access, ODBC, or any other database, and add-ins were already loading. So clearly it's timing out waiting on a call to a DLL which Access loads. In general, if you find an Office application is pausing on doing something it's likely waiting for a response from something that's not loaded. Try opening all the applications using actual files and see if it helps.

Thanks again for your help!

Anonymous said...

Haha, I can't believe adding an add-in actually worked! I've been doing the open / force close / open ritual for months!

Anonymous said...

Your add in solution worked for me, excellent, thank you. Can't believe I have been suffering for so long!