Forum Discussion
File Save As takes 20-30 seconds for Dialogue to appear
Latest Feature Update & Quality Update of Windows 10 21H1
Latest Update of Microsoft 365 / Office 365 - Excel
We have a customer complaining that their PC is running slow, he is a heavy user of Excel.
Upon investigation it was determined that the problem appears to be that when he tries to save or Save as an existing or new Excel Workbook, it takes 20-30 seconds for the Dialogue to save or Save as to appear.
This is a domain joined PC, with a number of mapped drives, One Drive configured.
The testing conducted are as follows:
- Trying to Save As an Existing or NEW Workbook even with one single cell with data in it - takes up to 30 seconds for the dialogue to enter the location and file name to appear
- Removed ALL Recent Files from the Recent List - No Change
- Ran the Office Repair from Control Panel - No Change
- Un-Install Office - Using Microsoft Office Removal Tool
- Re-Install Office from Scratch - No Change
- Logon as a different user to the current user - Works OK, takes a few seconds for the Dialogue to appear.
Seems to be User Profile related, it seems like one other user is having the same problem, no other users are complaining of this.
The next step is going to be to re-install Windows 10 which seems a bit over the top.
If anyone has any ideas?
You don't have to do any of what is suggested above. The following works perfectly to get rid of slowness when opening "save" and "save as" dialogues.
The steps below come from the following video: https://www.youtube.com/watch?v=RTvM0tvc0c8
The slow opening of the save and save as dialogues is caused by too many files in the directory: C:\Users\NAME\AppData\Roaming\Microsoft\Windows\Recent\AutomaticDestinations
I had about 459 files in that directory. Following the steps below solved the issue:
The steps to take according to the video are:Delete everything in this directory (substitute for NAME the correct name of your profile):
C:\Users\NAME\AppData\Roaming\Microsoft\Windows\Recent\AutomaticDestinations(As a contingency, it might be prudent to move all those files to another directory temporarily before completely deleting them.)
Do a Windows Key + X and choose Terminal (Admin).
At the prompt, enter: net stop server
Let it the server stop - you'll get a message it has stopped
At the prompt, enter: net start server
After the server restarts, reboot Windows and the dialogues should open very promptly once again.- Check his profile for any mapped drives which are no longer working. They may not be visible in Windows Explorer. (I think you can use Net Use in an admin command prompt for that). Delete the ones that are not working.
