Excel is running extremely slow.

%3CLINGO-SUB%20id%3D%22lingo-sub-2171786%22%20slang%3D%22en-US%22%3EExcel%20is%20running%20extremely%20slow.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171786%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20excel%20is%20not%20responding%20as%20fast%20and%20crashes%20at%20some%20point.%26nbsp%3B%20It%20also%20said%20that%20the%20file%20can't%20be%20open%20and%20update%20location%20everytime%20I%20try%20to%20open%20it.%26nbsp%3B%20Can%20anyone%20please%20look%20into%20it%20and%20find%20out%20what's%20wrong%20and%20fix%20it%20for%20me%2C%20please%3F%26nbsp%3B%20I%20am%20not%20an%20expert%20and%20need%20to%20work%20on%20the%20file%20which%20I%20haven't%20done%20in%20two%20weeks%20and%20it%20hurts%20my%20business.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2171786%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172235%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20is%20running%20extremely%20slow.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921074%22%20target%3D%22_blank%22%3E%40PanasW56%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20workbook%20requires%20connection%20to%20other%20files%20which%20is%20kept%20on%20Dropbox%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258720i2D712D0CF277B9CA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThey%20are%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20523px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258721i81043B601F3313E3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EFew%20formulas%20work%20with%20these%20external%20workbooks%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20699px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258727i6A5AE1F6980D2D15%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20addition%2C%20you%20have%20duplicated%20names%20for%20ranges%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20441px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258728i8F640BDA4C5E8253%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20ignore%20all%20above%20(i.e.%20connections%20with%20external%20files)%20there%20are%20no%20serious%20errors%20with%20the%20file%2C%20it%20works.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20not%20an%20author%20of%20the%20file%20it's%20better%20to%20ask%20him%20to%20find%20an%20issue%20and%20fix%20it%20in%20real%20environment.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

My excel is not responding as fast and crashes at some point.  It also said that the file can't be open and update location everytime I try to open it.  Can anyone please look into it and find out what's wrong and fix it for me, please?  I am not an expert and need to work on the file which I haven't done in two weeks and it hurts my business.

3 Replies

@PanasW56 

Your workbook requires connection to other files which is kept on Dropbox

image.png

They are

image.png

Few formulas work with these external workbooks

image.png

In addition, you have duplicated names for ranges

image.png

If ignore all above (i.e. connections with external files) there are no serious errors with the file, it works.

 

If you are not an author of the file it's better to ask him to find an issue and fix it in real environment.

@Sergei Baklan 

Thanks, but how do I fix it according to your instructions?

 

Panas

@PanasW56 

Without having entire environment with it's hard to say something concrete. You may try on copy of your file delete sheet by sheet, perhaps that's help to localize the reason.