At first I thought it only happened when I was clicking on files stored on a network shared folder instead of my local hard drive, as suggested in a few forum posts. In the forums where people have discussed this problem (for example here, here, and here), there have been various theories that have been floated and discarded. Yet I have only rarely heard about it from clients, and there are only scattered reports online. I replaced my desktop computer in part to get a fresh start on this problem it turned up almost immediately and has never left.
It has happened to me on my desktop and on several laptops on computers upgraded from Windows 7/8 and computers with clean installs of Windows 10 on computers with Office 2013 and Office 2016. There is very little pattern to when this problem occurs, as far as I can tell from Googling around. Thirty seconds later, out of nowhere, Excel starts up. People have sniffed with Process Explorer and Task Manager and looked at memory use and there is zero indication that anything is proceeding under the hood.
During the 30-60 second delay, nothing is happening.All other programs (including Word) are completely normal. If you remember to start Excel first, or if it is already running with another file open, then the clicked file will load immediately. There is no delay if Excel is already running when you double-click the file.There are some strange things about what happens. XLSX spreadsheet file is followed by a 30-60 second delay before the Excel logo appears and the spreadsheet loads normally. On some computers, double-clicking to open a. It happens on Windows 10 computers running Excel 2013 or Excel 2016. This bug only affects a small number of people, but it’s an interesting one because it’s been a problem for almost a year and there’s still no clear understanding of what’s going on. To be more productive with Microsoft Excel, check out these additional shortcuts, tips, and techniques at /Excel.Followup 07/2017: A Possible Fix For The Excel Slow File Opening Bug However, with the Excel backup feature, you can feel a little bit more comfortable making changes and working actively with your Excel workbooks. Keep in mind that this AutoBackup process is not a substitute for a regular system backup, whether it’s by your IT services, your files are saved in OneDrive or another cloud service, or you work with an automated backup service. If you open the Excel backup file, you may be prompted to confirm you want to open the file. And then, if you need to, you could actually open up this backup file which would reflect the changes prior to the last time the file was saved. Although the extension makes it a little bit easier to locate the backup file, it should be easy for you to find the file because they are named differently. If you’re not seeing the file extension from Windows Explorer, choose the View tab in the Ribbon and then select File name extensions. XLK extension and “Backup of” and then the file name. The AutoBackup updates the backup copy automatically, and so it’s up to date and one version behind the original, and other users don’t even need to know about the file. Basically, the backup file is always one version behind the current version. The third time you save it, however, the backup file will be updated with information up to the second save. If you make edits to the original file and then save it again, the backup file will still remain the same (the original data). Note that the first time you save, the files will be exactly the same. XLK extension and is stored in the same location as the original. Now, every time you make a change in the original spreadsheet and save it, the Excel backup file is updated to reflect your spreadsheet before that last save. Check the box next to “ Always create backup“.Choose the Tools button then General Options in the Save As dialog window.Click “ More options…” under the save location.With the file open, choose File > Save As.Follow these steps to set up an automatic backup for your key Excel workbooks: