ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Sheet Size (https://www.excelbanter.com/excel-worksheet-functions/219175-excel-sheet-size.html)

Julie

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

Gord Dibben

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