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.
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.