formatted whole page, file is now huge

[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

 

[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).

 

[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]

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

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.

 

[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.

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]

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

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.