Forum Discussion
Slow Excel Sheet - Even after everything's deleted
Okay, this one blows my mind. I have a sheet with a table that acts like it contains volatile formulas. It's very laggy, filtering is super slow, manual inputs are slow. Even after I have deleted everything on the sheet!!! All the things I tried below are after I deleted all data in the sheet.
File size is only 8MB. First thing I checked was VBA and it does have a macro that runs a worksheet change event. This was all commented out and still runs like this.
I checked Formula Names to see if there were any external connected workbooks, and there was not.
I checked Queries & Connections and there are none.
One strange thing I noticed is when I select any other sheets in the workbook it selects the sheet instantly and I can work quickly or as normal in the sheet without any hesitation or lag. When I go back to the problem sheet and click on it, it is slow to react.
Any cell within that sheet that I select (non edit mode or edit mode) it lags behind about 2-3 seconds before selecting it.
I do not have any other workbooks open and little to no other programs open. I have a laptop with high specs that could run circles around most laptops.
I don't know what else to check that would potentially fix this issue. Re-building this workbook will take way too long, potentially days.
Oh, I use MS 365 Enterprise 4 with the latest updates and I am on Current Channel using Win 10.
- Solved my problem. I'll post in case it helps another user out there. Check to ensure you do not have too many objects, comments or shapes in your sheets. This can be caused by copy and paste procedures inadvertently pasting them many times over without you realizing it. Simply, select the Home option in Excel ribbon and use the drop down under Find and Select. Select selection panel and you will see to the right if you have a lot of items showing that need to be deleted.
- Solved my problem. I'll post in case it helps another user out there. Check to ensure you do not have too many objects, comments or shapes in your sheets. This can be caused by copy and paste procedures inadvertently pasting them many times over without you realizing it. Simply, select the Home option in Excel ribbon and use the drop down under Find and Select. Select selection panel and you will see to the right if you have a lot of items showing that need to be deleted.
Consider yourself an expert now.
