ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My file is 20MB but there appears to be nothing in it. (https://www.excelbanter.com/excel-discussion-misc-queries/150520-my-file-20mb-but-there-appears-nothing.html)

excel_wizard

My file is 20MB but there appears to be nothing in it.
 
I have an excel spreadsheet with around 40 tabs in it. I have totally
deleted everything in it yet the file is still 20MB. How can I find what is
creating this 20MB?

bj

My file is 20MB but there appears to be nothing in it.
 
have you closed it and reopened it?
a lot of size does not go away until you have closed and reopened.
Check to see if there are hidden sheets.
on each sheet try edit-goto-special-last cell

"excel_wizard" wrote:

I have an excel spreadsheet with around 40 tabs in it. I have totally
deleted everything in it yet the file is still 20MB. How can I find what is
creating this 20MB?


Dave Peterson

My file is 20MB but there appears to be nothing in it.
 
I'd start by going into each sheet and seeing if there were any objects
(pictures/buttons/etc) on them.

Select a sheet
edit|goto special|Objects
and hit delete to delete the selected objects (if there were any)


excel_wizard wrote:

I have an excel spreadsheet with around 40 tabs in it. I have totally
deleted everything in it yet the file is still 20MB. How can I find what is
creating this 20MB?


--

Dave Peterson


All times are GMT +1. The time now is 09:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com