In File Explorer, go to the View menu and clear the Hidden items check box.Ĭlose File Explorer, and then start Excel. The C:\Users\ User_Name\AppData\Roaming\Microsoft\Excel folder should be empty.
Use Windows Cut and Paste to move all the files and folders from the directory you created in the previous step to the backup folder that you created in step 2. Replace User_Name with your Windows login user name. Navigate to: C:\Users\ User_Name\AppData\Roaming\Microsoft\Excel Open Windows File Explorer, then select the View menu, and then select the check box to show Hidden items. This is to ensure that there are no hidden instances of Excel running in the background.Īfter the reboot, create a folder on your computer (for example, in the Desktop or the Documents folder) and give is a descriptive name (for example, Excel AppData Backup). To improve Excel performance when opening a workbook:Ĭlose all applications and restart your computer once. You can back up the contents of this folder and then clear the folder to improve performance when opening a workbook.
Sometimes, temporary files and folders stored in the C:\Users\ UserName\AppData\Roaming\Microsoft\Excel folder can cause issues when trying to open a workbook file in Excel. Some people have reported opening Excel files on a network share can be delayed due to updates: KB2541025, KB2502786, KB2509503 On the one I encountered I only had to remove the first update Slow opening of files, especially Office files, is often related to Windows searching for old links that no longer exist.