Big excel file with nothing in it?

[fklioside]

Hi everyone,

I have a excel file with 30+ tabs which makes the file about 3.6 mb. When I copy one individual sheet, it is still 3mb. I can't figure out what is causing it to be big. I even deleted all the rows and columns and there is no data anymore in the sheet but it is still big. We ran some vba macros to rename sheets and to split worksheet tabs out so I am thinking is there some kind of vba cache or something that it is carrying over every time we make a copy of the sheet? I really need to fix the master booksince the entire workbook is 3.6 mb and when we split the 30+ sheets in it they are still all 3 mb each.

https://mahercomm.box.com/s/y1nqyl61p2v9zxifxtkyecl4n04wcapv

Any insight would help and be greatly appreciated!

Thanks!

 

[Youngdand]

Do you have any hidden rows or columns?

 

[Fluff]

Delete the named ranges

 

[fklioside]

No hidden rows or columns or named ranges. I created a fresh worksheet and deleted all the other ones and now it is blank but the entire workbook is still 3mb.

 

[fklioside]

the link is a copy of the file if anyone can see what is wrong with it, thank you!

 

[Fluff]

The file that you supplied has 2 named ranges. After deleting them the file came down to 12K

 

[fklioside]

Ah thank you so much, didn't realize named ranges still stick after deleting all the worksheets.

Thanks!

 

[Fluff]

Glad to help & thanks for the feedback