While openen .XLS (excel 97 - 2003) files from a network drive (DFS), it takes quite a while to open these files (30 seconds or more). These delays only occur under certain circumstances:
- Files need to be .XLS files (.XLSX opens without problems)
- Files need to be on the network drive (If we copy the files to the local drive, there are no problems)
- Files need to be opened as editable (opening them read-only, opens the files immediatly)
When I check the opened file for errors, Excel reports problems with a stored absolute path.
Removing this path, and then saving the file (to the network) solves this problem.
Unfortunalty, we can't edit all files. Some are created password-protected by certain applications, and changing all the documents we created in the last two decades seems a bit of a weird thing to do.
The question is, why do we suddenly (problems seems to have arrisen in the last 2to 4 months) recieve these errors?
Stuff we tried: Disable Cortana (we don't have cortana), Remove/replace Realtek audio drivers (We use Dell machines, and this apperently can cause problems). Only thing that apperenntly helps is removing the absolute path and then save the file. Strange thing is, when I create a new .XLS file (with no content) and save it to the network drive, it still opens extremely slow.