Jan 26 2018 11:11 AM
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
Jan 26 2018 11:13 AM
Jan 26 2018 11:17 AM
Jan 27 2018 02:11 AM
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.
Jan 29 2018 04:08 AM
Jan 29 2018 07:53 AM
Jan 29 2018 07:55 AM
Jan 29 2018 08:47 AM