| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet Size
I have a workbook with three tabs and about 100 rows of data in each. It
currently is 63 mb. Does anyone know why it would be so large? I have having problems savings and opening the document and am afraid it will close down due to the size. Can anyone know how to avoid getting the workbook to be so large or what might be the cause? Please let me know! Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Sheet Size
If you CTRL + End on a sheet where does Excel take you?
If far below and right of your actual data range, select all rows below your actual data and EditDeleteEntire Row Same for columns to the right. Do for each sheet. Now save the workbook. Close and re-open. Any change in size? Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 14:42:19 -0800, Julie wrote: I have a workbook with three tabs and about 100 rows of data in each. It currently is 63 mb. Does anyone know why it would be so large? I have having problems savings and opening the document and am afraid it will close down due to the size. Can anyone know how to avoid getting the workbook to be so large or what might be the cause? Please let me know! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| Excel sheet size | Excel Discussion (Misc queries) | |||
| How can I increase footer size in an Excel sheet? | Excel Discussion (Misc queries) | |||
| How can I change the font size on an Excel sheet tab? | Excel Discussion (Misc queries) | |||
Linear Mode
