Forum Discussion
.XLS Files open extremely slow from network drives.
Raul_Chiarella It has been a few years since I had this problem. I know it took a few weeks, a lot of Googling and testing to solve this. Unfortunately I don't know where I found the solution. And I don't know if you have the exact same problem. In our case it had to do with the Personal Templates location in Excel (and Word, Powerpoint etc.). I used a .reg-file to fix this.
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options]
"personaltemplates"="K:\\Corporate identity\\Templates"
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\PowerPoint\Options]
"personaltemplates"="K:\\Corporate identity\\Templates"
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options]
"personaltemplates"="K:\\Corporate identity\\Templates"
K: is a networkmapped drive. I think we had problems with UNC paths.
You could try with an empty location , or you own harddrive or a network-location.
Please note the double \\ symbols in the location for regedit. And use your own location, as our K:-drive should not be accessable to you (Looks at our network engineer.).
Backup your register before applying this (hopefully) fix.
( Note to myself: Please write documentation for stuff I've solved 😄 )
- Erik_PlekenpolJun 17, 2021Copper Contributor
Raul_Chiarella The .reg-file should be run on each client, not on the (file)server. If you don't use centralised templates, you probably should set the personaltemplates path to an empty string "" .
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options]
"personaltemplates"=""