A zero number or blank default will turn off caching. Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support. This situation may occur after you click Open in the Open dialog box on the File menu, click Open to open a file from a network location for example, a network server.
During the process of opening the file, you lose your network connection or the network location that contains the file that you are trying to open goes down. During the process of opening the file, your Office program tries to add the file name and the path information of the file that you are trying to open to the Windows recent file list.
Because the network location path does not now exist, the Office program may run slowly and may appear to stop responding hang. This situation may also occur if your connection to your network is slow because your Office program has to make multiple queries to the network to obtain the correct file information. Skip to main content. This browser is no longer supported.
At , Chris Newland left the following comment Hi Dan, Actually this fixed my problem for slow-opening of local files as Excel was still trying to scan network locations even when the file had no external references. At , damagyar left the following comment Unfortunately, it did not resolve the issue. I see you posted your solution in April of This should not be happening.
Do you have any other suggestions that may resolve this issue? At , Dusty Nebulus left the following comment I have been working on this exact problem for the last 5 hours. I have scoured the internet, and nobody had the answer that worked until I found your solution. At , skp left the following comment Thousand thanks about your information.
It really solve my problem of wasting time for waiting At , Avi left the following comment So simple solution!! At , Mike left the following comment Thanks so much for this fix! I've got an xlsm file that takes over 2 minutes to open. When I save it as an xlsb it opens almost immediately. However if I resave it as an xlsm again the slow open issue reoccurs. Has anyone got any ideas what the cause might be? More info: I've tested the recalculation times on both versions and they are the the same.
The count of cells used in each sheet are the same. The number of custom styles is the same. The PC is Win7. I have the same question Report abuse. Details required :.
Cancel Submit. Bill Manville MVP. What size is the file? How satisfied are you with this reply?
0コメント