An Office program is slow or may stop responding (hang) when you open a file from a network location
When you try to open a file from a network location in one of the Microsoft Office programs such as PowerPoint 2003 , Excel 2003, Publisher 2003 or a later version of them, the Office program may run very slowly or may appear to stop responding (hang).
This behavior may occur if the connection to the network location is lost during the time that your Office program is opening the file.
This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, see How to back up and restore the registry in Windows.
To work around this behavior, add the EnableShellDataCaching value to the Microsoft Windows registry. To do this, follow these steps:
Close your Office programs.
Click Start, and then click Run.
In the Open box, type regedit, and then click OK.
Locate, and then click to select one of the following registry keys accordingly:
Office 365, Office 2019 and Office 2016:
After you select the key that is specified in step 4, point to New on the Edit menu, and then click DWORD Value.
Type EnableShellDataCaching, and then press ENTER.
Right-click EnableShellDataCaching, and then click Modify.
In the Value data box, type 1, and then click OK.
Any non-zero number in the Value data box will turn on caching. A zero number or blank (default) will turn off caching.
On the File menu, click Exit to quit Registry Editor.
Did this fix the problem?
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.