Forum Discussion
Excel bulky worksheet
- Sep 08, 2023
Here's how to resolve it.
1. Open the workbook but don't go to the "Interest Deal" sheet
2. Press Alt+F11 to open the Visual Basic Editor
3. In VB Editor, go to view and show Immediate Window (it will show at the bottom).
4. Enter the following in the immediate window and then press enter:
Sheets("Interest Deal").pictures.delete
Immediate window looks like this (it's whited out because it's taking a while):
5. Go to lunch or dinner and then come back. You have 68,000 pictures in that sheet. It will take a while to remove those.
Try this:
And the web is full of answer why a workbook is slow. Go and search.
- sirmanojSep 08, 2023Copper ContributorNot working for my file. I have searched 100s of YouTube videos, searched web and also used chatgpt for my problem but I have not received any satisfactory answer. I am struggling for this issue for last 2 years. As a last resort I am posting my issue here not as the first. It's work related classified data in that file otherwise I could have shared those files here also.
- Patrick2788Sep 08, 2023Silver Contributor
What if you clear all data (and metadata) out of the workbook and then upload here so we may take a look? I suspect the problem is not the data but could be an excessive amount of objects (not visible to the eye) or an exorbitant amount of styles.