Forum Discussion
sirmanoj
Sep 08, 2023Copper Contributor
Excel bulky worksheet
In my excel file one sheet has become very bulky. There are no conditional formattings, no dynamic formulae. The visible data is also just 10-12 rows in that sheet. I have one or two conky columns in...
- 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.
sirmanoj
Sep 08, 2023Copper Contributor
https://1drv.ms/x/s!AqGXCNtqu1XwkUvRSIr1uOSuXM9y?e=0xty0a
Uploaded the file in my onedrive
Here is the link please give me some solution both deal sheets are an issue
Uploaded the file in my onedrive
Here is the link please give me some solution both deal sheets are an issue