Forum Discussion
Excel bulky worksheet
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.
Uploaded the file in my onedrive
Here is the link please give me some solution both deal sheets are an issue
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.
- Thanks a lot. It worked like a magic.
- Glad it worked! I hope the workbook is a lot easier to work with now.