Home

.XLS Files open extremely slow from network drives.

%3CLINGO-SUB%20id%3D%22lingo-sub-465882%22%20slang%3D%22en-US%22%3E.XLS%20Files%20open%20extremely%20slow%20from%20network%20drives.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-465882%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20openen%20.XLS%20(excel%2097%20-%202003)%20files%20from%20a%20network%20drive%20(DFS)%2C%20it%20takes%20quite%20a%20while%20to%20open%20these%20files%20(30%20seconds%20or%20more).%20These%20delays%20only%20occur%20under%20certain%20circumstances%3A%3C%2FP%3E%3CP%3E-%20Files%20need%20to%20be%20.XLS%20files%20(.XLSX%20opens%20without%20problems)%3C%2FP%3E%3CP%3E-%20Files%20need%20to%20be%20on%20the%20network%20drive%20(If%20we%20copy%20the%20files%20to%20the%20local%20drive%2C%20there%20are%20no%20problems)%3C%2FP%3E%3CP%3E-%20Files%20need%20to%20be%20opened%20as%20editable%20(opening%20them%20read-only%2C%20opens%20the%20files%20immediatly)%3C%2FP%3E%3CP%3EWhen%20I%20check%20the%20opened%20file%20for%20errors%2C%20Excel%20reports%20problems%20with%20a%20stored%20absolute%20path.%3C%2FP%3E%3CP%3ERemoving%20this%20path%2C%20and%20then%20saving%20the%20file%20(to%20the%20network)%20solves%20this%20problem.%3C%2FP%3E%3CP%3EUnfortunalty%2C%20we%20can't%20edit%20all%20files.%20Some%20are%20created%20password-protected%20by%20certain%20applications%2C%20and%20changing%20all%20the%20documents%20we%20created%20in%20the%20last%20two%20decades%20seems%20a%20bit%20of%20a%20weird%20thing%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20question%20is%2C%20why%20do%20we%20suddenly%20(problems%20seems%20to%20have%20arrisen%20in%20the%20last%202to%204%20months)%20recieve%20these%20errors%3F%26nbsp%3B%3C%2FP%3E%3CP%3EOS%3A%20Win10%201803%20%26amp%3B%201809%3C%2FP%3E%3CP%3EOffice%20version%3A%20Semi-annual%20channel%20(non-targeted)%26nbsp%3B%3C%2FP%3E%3CP%3EStuff%20we%20tried%3A%20Disable%20Cortana%20(we%20don't%20have%20cortana)%2C%20Remove%2Freplace%20Realtek%20audio%20drivers%20(We%20use%20Dell%20machines%2C%20and%20this%20apperently%20can%20cause%20problems).%20Only%20thing%20that%20apperenntly%20helps%20is%20removing%20the%20absolute%20path%20and%20then%20save%20the%20file.%20Strange%20thing%20is%2C%20when%20I%20create%20a%20new%20.XLS%20file%20(with%20no%20content)%20and%20save%20it%20to%20the%20network%20drive%2C%20it%20still%20opens%20extremely%20slow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20highly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EErik%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-465882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Erik_Plekenpol
Visitor

Hello,

 

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? 

OS: Win10 1803 & 1809

Office version: Semi-annual channel (non-targeted) 

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.

 

Any help is highly appreciated.

 

Erik

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies