formatted whole page, file is now huge

I

Ian Elliott

Thanks for any help. I formatted the whole page (down to row 65536, and the
rightmost row) for a bunch of pages, and now the file is 55MB, when it was
about originally 6MB. I tried going back to those pages and doing a format
general, but that didn't help. Any suggestions much appreciated!
Thanks
 
M

macropod

Hi Ian,

If you delete the unnecessarily formatted rows and columns, then save the workbook, that should reduce its size to about what you
had before (maybe even smaller).
 
C

CurlyDave

Hi Ian,

If you delete the unnecessarily formatted rows and columns, then save theworkbook, that should reduce its size to about what you
had before (maybe even smaller).

--
Cheers
macropod
[MVP - Microsoft Word]

Ian Elliott said:
Thanks for any help. I formatted the whole page (down to row 65536, andthe
rightmost row) for a bunch of pages, and now the file is 55MB, when it was
about originally 6MB. I tried going back to those pages and doing a format
general, but that didn't help. Any suggestions much appreciated!
Thanks
Click to expand...
Click to expand...

Select the rows not being used and goto Edit Clear All, then select
all the unused Columns and goto Edit Clear All, Then re-save the
workbook.
 
I

Ian Elliott

Macropod and CurlyDave,
Thank you very much!!!!!!
I thought I might have to spend a couple more hours to rebuild them from
scratch. You saved me time & worry. Thanks again.
I used Macropod's method first, and since that worked, I didn't use yours
CurlyDave, but if I need to, I will.
Thanks alot.


CurlyDave said:
Hi Ian,

If you delete the unnecessarily formatted rows and columns, then save the workbook, that should reduce its size to about what you
had before (maybe even smaller).

--
Cheers
macropod
[MVP - Microsoft Word]

Ian Elliott said:
Thanks for any help. I formatted the whole page (down to row 65536, and the
rightmost row) for a bunch of pages, and now the file is 55MB, when it was
about originally 6MB. I tried going back to those pages and doing a format
general, but that didn't help. Any suggestions much appreciated!
Thanks
Click to expand...
Click to expand...

Select the rows not being used and goto Edit Clear All, then select
all the unused Columns and goto Edit Clear All, Then re-save the
workbook.
Click to expand...
 
Top