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 |
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 |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com