May 02 2018 11:38 AM
One of our users has a problem with Excel 2016 (Office 365 user).
The user has a map with about 15 excel sheets, which he wants to open one at a time. The first time the user opens a sheet it opens fast, but after about 2 or 3 sheets, it can take up to 10 seconds before Excel opens the sheet.
Now I already searched and tried several solutions, but until now I haven't found a working solution for it.
These things I already have tried:
- Uninstall Office 365 and reinstall it
- Restore Office 365
- Installed all updates
- Disabled all add-ins
- Disabled hardware acceleration
- Uninstalled the audio software (from HP)
- Enabled SuperFetch service (this was already enabled)
- Hi Cortana service isn't available on the PC, because it isn't available in Dutch yet
- Changed the standard printer
- Disabled settings for protected view en file blocking
- Ignore other application which uses Dynamic Data Exchange (DDE)
- Removed Excel roaming filed (%appdata%\Microsoft\Excel)
- Monitored it with Procmon, I don't see anything with that that could be interfering with Excel
It doesn't matter if the Excel sheets are stored locally, on a NAS or on OneDrive.
There isn't any other security software running, besides Microsoft Defender.
The PC is only 2 months old, it's a Core i5 HP Pro PC with 8GB memory, 256GB SSD, 1TB HDD.
Is there any other solution I can try to solve the long startup time for Excel?
May 02 2018 04:11 PM
SolutionHi Alexander,
I'm not sure in result, but you may try to open your files in separate instances.
Here is how to change default behaviour https://support.microsoft.com/en-gb/help/3165211/how-to-force-excel-to-open-in-a-new-instance-by-def...
but before change the registry I'd test in batch file with commands like
excel /x "c:\my path\my file.xlsx"
with and without /x if any difference
May 03 2018 12:23 PM
Thanks, it looks like that's working. I will ask the user to see if it's now solved to his satisfaction now. I'll let it know as soon as I have an answer.
May 03 2018 01:43 PM
Yes, please share the info when ready. I personally didn't play with that, it will be interesting to know the result.
May 04 2018 03:51 PM
A little bit of a late reply, but the good news: Your suggestion works!
Thank you very much!
May 02 2018 04:11 PM
SolutionHi Alexander,
I'm not sure in result, but you may try to open your files in separate instances.
Here is how to change default behaviour https://support.microsoft.com/en-gb/help/3165211/how-to-force-excel-to-open-in-a-new-instance-by-def...
but before change the registry I'd test in batch file with commands like
excel /x "c:\my path\my file.xlsx"
with and without /x if any difference