Forum Discussion
heylookitsme
Apr 02, 2024Iron Contributor
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 eve...
- Apr 02, 2024Solved 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.
heylookitsme
Apr 02, 2024Iron Contributor
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.
- Detlef_LewinApr 02, 2024Silver Contributor
Consider yourself an expert now.