.XLS/.PPT Files extremely slow when opening from network drive (Win Server 2019)

%3CLINGO-SUB%20id%3D%22lingo-sub-2455235%22%20slang%3D%22en-US%22%3E.XLS%2F.PPT%20Files%20extremely%20slow%20when%20opening%20from%20network%20drive%20(Win%20Server%202019)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455235%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20opening%20any%20Office%20file%20(.XLS%2C.PPT%2C.DOC%2C%20etc)%20(excel%2097%20-%202003)%20from%20my%20network%20drive%20(File%20Server%20Windows%20Server%202019)%2C%20it%20takes%20a%20LOOONG%20time%20to%20open%20it!%20(1-3%20minutes)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20problem%20only%20occurs%20under%20the%20following%20circumstances%3A%3C%2FP%3E%3CP%3E-%20File%20need%20to%20be%20office%20extension%20and%20type%20needs%20to%20be%2097-2003%20-%20So%20Office%20opens%20it%20in%20compatibility%20mode.%3C%2FP%3E%3CP%3E-%20File%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-%20File%20need%20to%20be%20opened%20as%20editable%20(opening%20them%20read-only%2C%20opens%20the%20files%20immediatly)%20.___.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease.%20I%20have%20no%20more%20CLUES%20on%20what%20can%20i%20DO!%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20give%20me%20a%20little%20light%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOffice%20version%3A%202016%20%26amp%3B%202019%3C%2FP%3E%3CP%3EThings%20i%20did%20to%20see%20if%20it%20solves%20the%20problem%3A%3C%2FP%3E%3CP%3E-%20Disable%20Cortana%20(we%20don't%20have%20cortana)%3C%2FP%3E%3CP%3E-%20Some%20other%20things...%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%3ERaul%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22LabelsForArticle%20lia-component-labels%20lia-component-message-view-widget-labels-with-event%22%3E%3CDIV%20class%3D%22LabelsList%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2455235%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2455322%22%20slang%3D%22en-US%22%3ERe%3A%20.XLS%2F.PPT%20Files%20extremely%20slow%20when%20opening%20from%20network%20drive%20(Win%20Server%202019)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455322%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20could%20try%20saving%20a%20copy%20of%20the%20files%20as%20xlsx%20files%20and%20see%20if%20that%20solves%20the%20problem.%3CBR%20%2F%3ERemember%20to%20save%20a%20COPY%20in%20case%20the%20file%20type%20change%20disrupts%20the%20data%20in%20the%20workbook.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20are%20not%20able%20to%20change%20the%20file%20type%20for%20whatever%20reason%20you%20could%20try%3A%3CBR%20%2F%3E%E2%80%A2%20Do%20a%20quick%20repair%20of%20the%20Office%20programs%20(Control%20Panel%20%2F%20Installed%20Programs%20%2F%20Change).%3CBR%20%2F%3E%E2%80%A2%20Check%20add-ins%20that%20run%20with%20Excel%20(File%20%2F%20Options%20%2F%20Add-ins)%20to%20see%20if%20anything%20looks%20dicey.%3CBR%20%2F%3E%E2%80%A2%20Open%20a%20blank%20Excel%20sheet%20and%20then%20open%20the%20Excel%20file%20(Excel%20will%20already%20be%20running%20when%20attempting%20to%20open)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello there,

 

While opening any Office file (.XLS,.PPT,.DOC, etc) (excel 97 - 2003) from my network drive (File Server Windows Server 2019), it takes a LOOONG time to open it! (1-3 minutes)

 

This problem only occurs under the following circumstances:

- File need to be office extension and type needs to be 97-2003 - So Office opens it in compatibility mode.

- File need to be on the network drive (If we copy the files to the local drive, there are no problems)

- File need to be opened as editable (opening them read-only, opens the files immediatly) .___.

 

Please. I have no more CLUES on what can i DO! 

Can someone give me a little light?

 

Office version: 2016 & 2019

Things i did to see if it solves the problem:

- Disable Cortana (we don't have cortana)

- Some other things...

 

Any help is highly appreciated.

 

Raul

 
2 Replies
Hi,

You could try saving a copy of the files as xlsx files and see if that solves the problem.
Remember to save a COPY in case the file type change disrupts the data in the workbook.

If you are not able to change the file type for whatever reason you could try:
• Do a quick repair of the Office programs (Control Panel / Installed Programs / Change).
• Check add-ins that run with Excel (File / Options / Add-ins) to see if anything looks dicey.
• Open a blank Excel sheet and then open the Excel file (Excel will already be running when attempting to open)
I just finished doing all this and it ditnt fix it...