File size 14mb opens to 150mb

  • Thread starter Thread starter Cresta
  • Start date Start date
C

Cresta

Help
I have a 14mb xlsm which eventually opens to 150mb. I have tried everything
I can to identify the problem, but can't.
I have notice the following in the vba editor, the VBAProject for this file
has two workbook objects, "ThisWorkbook" and "Sheet19", both having and icon
with an X on a white page, (not the same as the worksheet icon). I know
"ThisWorkbook" should stay but i cannot remove "Sheet19".
Question 1 - should there be two workbooks shown in one file.
Question 2 - can the second one be deleted if it shouldn't be there.
Question 3 - any ideas for the large active filesize if the above isn't the
problem.

Thanks All
 
FWIW, I have also experienced the phantom workbook object (XL2003 on WinXP)-
in my case, I was unable to find a way to remove it. I work with large
files, but have not experienced the 10x bloat you describe (at least not
that I've noticed).

That doesn't eliminate it as a potential problem, but I'd probably look at
other factors for workbook bloat.

Keith
 
Back
Top