Large excel file size for unknow reasons

[gurmeet singh]

We have an excel file which has become of size 2.5MB and
it has no graphics in it - cells with text and data only.
Also, we tried cut the sheet and copying it on a new excel
sheet and paste process will never finish and we find CPU
utilization has gone to 100%.

Any suggestions/thoughts on what may be wrong?

Thanks for your help

....gurmeet

 

[jeff]

Have you tried deleting all empty columns and rows. I
find this usually helps

 

[Norman Harker]

Hi Gurmeet!

Sometimes the size of a Excel file can blow out to several megabyte
with very little apparent change to the cell. The most common problem
relates to the last cell of each worksheet.



Use:

Edit > GoTo > Special

Check "Last Cell"

OK

Does it take you a lot further than you should go? If, "Yes", then you
need to delete all rows below the "real" bottom of your data and all
columns to the right of the furthermost column used by your data.



For each sheet in turn:

To reset the last row:

Select cell A one row down from the last cell with data.

Press and continue to hold down Ctrl + Shift keys, and then press the
Down Arrow key.

Right-click > Delete

Check "Entire Row"

OK.



To reset the last column:

Select Row 1 of the last column with data in it.

Press and continue to hold down Ctrl + Shift keys, and then press the
Right Arrow key.

Right-click > Delete

Check "Entire Column"

OK.



Having checked / done each sheet, Save the file although with Excel
2000 and before you have to use:



Save, Close, Open, Save


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 22nd July: Gambia (Liberation Day),
Poland (National Liberation Day), Slovenia (People's Uprising Day),
Swaziland (Birthday King Sobhuza II)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Gurmeet!

I should have added see:

Debra Dalgleish:
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 22nd July: Gambia (Liberation Day),
Poland (National Liberation Day), Slovenia (People’s Uprising Day),
Swaziland (Birthday King Sobhuza II)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Louise Smith]

Hi Gurmeet,

Has formatting been applied to the cells by first selecting the ENTIRE
worksheet (Select All)?

A worksheet consists of Columns A to IV and Rows 1 to 65,536 whether
you have data in those cells or not. If the entire worksheet is
selected when formatting is applied, the formatting is applied to ALL
of the cells, even those without data. This can significantly impace
file size.

Hope this helps,

Louise