I'm having a problem with Excel 2010 on Windows 7. I've just changed my laptop from a 3-year-old one to a brand new machine and installed Office 2010 just like on the previous one. And now Word and OneNote open in a blink of the eye, with prominent exception to Excel. Clicking on a desktop file causes, at time, a few seconds up to 20-30 second wait for spreadsheet to open.
I've been here: http://social.technet.microsoft.com/Forums/en-ZA/excel/thread/e1b5c693-6bca-4f4f-971e-13d3d3d10b37 here: http://social.technet.microsoft.com/Forums/en-US/excel/thread/4801f640-8aaa-4f43-99ce-d6135ad0f878 and here: http://social.technet.microsoft.com/Forums/en-US/excel/thread/2816e64d-b6e7-4c30-9278-23f7a2ff9bac and here: http://excel.itags.org/microsoft-excel/149168/
and the conclusion is that removing DDE option (/dde -> "%1") in registry as described in the last (and some other) website works. But I see it as a nasty hack. I tried uninstalling SP1, reparing Office, removing and reinstalling Office (but I haven't tried to reinstall Windows and I would like not to). Still, my old laptop can open Excel files faster than the new one. Of course Word and OneNote take miliseconds to load so I think it's obvious what to blame.
So does anyone know anything about DDE problems that haven't been said in the above threads (or did I miss something)? May it be a program/laptop utility/driver that interferes with Excel on new machine while on the older one it worked fine?
Thanks in advance for any hints.
Thank you for your question.
We are looking at this issue. There might be some time delay. Appreciate your patience.
Thank you for your understanding and support.
The issue is due to legacy files/add-ins that have not been opened and saved in the new client. You can troubleshoot which files/add-ins are causing this by removing them one by one or by removing them all if you don't use them. The following KB describes how to troubleshoot startup issues with Excel: Remove old unused XLA add-ins via KB280504 How to troubleshoot startup problems in Excel (http://support.microsoft.com/default.aspx?scid=kb;EN-US;280504)
Otherwise you can do the following:
- Open the XLA, go to VBA, save the XLA and close
- Regarding legacy Personal workbooks: open Excel click View/Unhide, rehide, close, say yes to save.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\TCSCConv.SharedAddin.14] "Description"="COM addin that convert between Traditional Chinese and Simplified Chinese." "FriendlyName"="Chinese Conversion Addin" "LoadBehavior"=dword:00000003
I removed the registry entry as above (I tried removing it peacefully be turning it off in Excel, but it turned of itself after running Excel again) and it seemed (at least that was my perception) that Excel got somewhat faster for a few (3-4) open/close sessions, but after opening and closing numerous spreadsheets the performance seems to have once again degraded to the level before removing the addin.
So it seemed to helped but the problem got back almost instantly.
Then I tried removing HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Excel and its HKCU counterpart but to no avail.
No other add-ins are active and the Addins key is removed. Also there should be no old XLAs. (This one is a fresh install - the old laptop had 2007 upgraded to 2010 so if there was a problem there, then I wouldn't be much surprised.) I checked for them in Program Files and in the user AppData folder.
And it's a shame the automatic FixIts wouldn't run for me :(
- Edited by Krzysztof J. Obara Tuesday, September 13, 2011 3:32 PM More info added
No, nothing of interest there... Plain view of three sheets as far as I'm concerned...
I should also add that opening XLSX file after restart is quite quick, but every subsequent run is slower and after opening and closing Excel repeatedly for a few times, the time between clicking on a file and Excel showing gets over 20 seconds.
The problem should not be with start-up programs as I waited 5 minutes after logging in for the start-up to complete before trying to run Excel for the first time.
Also, advised in other forums I tried removing updates for Excel (but not for Office). However, no success there as well.
- Edited by Krzysztof J. Obara Monday, September 19, 2011 1:31 PM More info provided
It appears your question falls into the paid support category which requires a more in-depth level of support. Please visit the below link to see the various paid support options that are available to better meet your needs. http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone.