formatted whole page, file is now huge
 

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

formatted whole page, file is now huge
 

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" wrote in message ...
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

formatted whole page, file is now huge
 

On Mar 13, 6:30*pm, "macropod" wrote:
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" wrote in ...
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.

formatted whole page, file is now huge
 

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" wrote:

On Mar 13, 6:30 pm, "macropod" wrote:
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" wrote in ...
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.