Home

Excel doc very slow

%3CLINGO-SUB%20id%3D%22lingo-sub-149314%22%20slang%3D%22en-US%22%3EExcel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149314%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20having%20a%20problem%20with%20a%20few%20excel%20docs.%20I%20had%20a%20ton%20of%20connections%20in%20%22query%20%26amp%3B%20connections%22%20tab%20and%20it%20was%20making%20it%20so%20slow%2C%20so%20i%20decided%20to%20delete%20all%20of%20em%20via%20VBA%20using%20a%20code.%20It%20worked%20but%20my%20doc%20still%20very%20slow.%20What%20possible%20issue%20can%20it%20be%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%20all%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-149314%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConnections%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Equery%20%26amp%3B%20connections%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eslow%20document%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149927%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149927%22%20slang%3D%22en-US%22%3ECan't%20you%20remove%20the%20sensitive%20information%20and%20send%20that%20sanitized%20version%20to%20me%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149897%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149897%22%20slang%3D%22en-US%22%3EI%20dont%20think%20it's%20possible%2C%20there%20are%20confidential%20informations%20in%20it%2C%20but%20i%20appreciate%20your%20help%20so%20much%20%3A)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149895%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149895%22%20slang%3D%22en-US%22%3EIf%20you%20wish%20I%20can%20take%20a%20quick%20look%20at%20yor%20file%2C%20see%20if%20I%20can%20find%20out%20why%20it%20is%20slow%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149794%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149794%22%20slang%3D%22en-US%22%3EI%20did%20it%20but%20it%20didn't%20find%20any%20objects%20and%20it%20does%20still%20very%20slow%20%3A%2F...%20Is%20there%20any%20other%20possible%20reason%20why%20this%20is%20working%20so%20slow%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20the%20computer%20that%20i'm%20using%20is%20an%20i5%2F%2016GB%20RAM%2C%20so%20i'm%20pretty%20sure%20that%20i%20have%20a%20pc%20good%20enough%20to%20run%20excel%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20again%20for%20replying%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149459%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149459%22%20slang%3D%22en-US%22%3E%3CP%3EMost%20likely%20there%20are%20many%20objects%20on%20the%20sheet.%20Press%20F5%2C%20click%20special%20and%20choose%20Objects.%20Does%20it%20find%20anything%3F%20If%20so%2C%20hit%20del%20key%20to%20delete%20them%20and%20see%20if%20performance%20improves.%20You%20may%20want%20to%20do%20this%20on%20a%20copy%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149318%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149318%22%20slang%3D%22en-US%22%3EEverything%20seems%20to%20be%20slow%2C%20like%20when%20i'm%20opening%20the%20doc%2C%20or%20trying%20to%20type%20something%20into%20a%20label%2C%20also%20trying%20to%20click%20on%20the%20tabs...%20everything...%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%2C%20i'll%20take%20a%20look%20on%20these%20functions%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149316%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doc%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149316%22%20slang%3D%22en-US%22%3EWhat%20is%20slow%2C%20calculation%3F%20Look%20for%20functions%20like%3A%3CBR%20%2F%3ESUMIFS%3CBR%20%2F%3EVLOOKUP%3CBR%20%2F%3EMATCH%3CBR%20%2F%3ESUMPRODUCT%3CBR%20%2F%3Eand%20for%20array%20formulas%3CBR%20%2F%3EThose%20types%20of%20functions%20are%20reknown%20for%20taking%20a%20lot%20of%20time%20to%20calculate%3C%2FLINGO-BODY%3E
Highlighted
Lucas Fernandes de Jesus
Occasional Contributor

Hey everyone,

 

I'm having a problem with a few excel docs. I had a ton of connections in "query & connections" tab and it was making it so slow, so i decided to delete all of em via VBA using a code. It worked but my doc still very slow. What possible issue can it be?

 

Thank you all

7 Replies
What is slow, calculation? Look for functions like:
SUMIFS
VLOOKUP
MATCH
SUMPRODUCT
and for array formulas
Those types of functions are reknown for taking a lot of time to calculate
Everything seems to be slow, like when i'm opening the doc, or trying to type something into a label, also trying to click on the tabs... everything...

Also, i'll take a look on these functions

Most likely there are many objects on the sheet. Press F5, click special and choose Objects. Does it find anything? If so, hit del key to delete them and see if performance improves. You may want to do this on a copy though.

I did it but it didn't find any objects and it does still very slow :/... Is there any other possible reason why this is working so slow?

Also the computer that i'm using is an i5/ 16GB RAM, so i'm pretty sure that i have a pc good enough to run excel

Thank you again for replying
If you wish I can take a quick look at yor file, see if I can find out why it is slow?
I dont think it's possible, there are confidential informations in it, but i appreciate your help so much :)
Can't you remove the sensitive information and send that sanitized version to me?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies