| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Huge File. | Excel Discussion (Misc queries) | |||
| How do I insert page breaks in a huge EXCEL file? | Excel Discussion (Misc queries) | |||
| i formatted an excel sheet, to fit my page, how do i add a page? | New Users to Excel | |||
| huge huge excel file... why? | Excel Discussion (Misc queries) | |||
| File got huge | Excel Discussion (Misc queries) | |||
Linear Mode
