Excel Sheet Size

[Julie]

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]

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 Edit>Delete>Entire 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

 

[Matt Richardson]

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 Edit>Delete>Entire 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



- Show quoted text -

There might be some help for you here:-

http://www.ozgrid.com/Excel/ExcelProblems.htm

Hope this helps,
Matt
http://teachr.blogspot.com