Huge sheet for no reason

  • Thread starter Thread starter Joel Dorfan
  • Start date Start date
J

Joel Dorfan

I have a worksheet with about 200 rows and 60 columns in one sheet and about
half that in another sheet.

The size of the file has become about 25MB!!
It had some word emebeded object (logos) which I deleted and the size only
went doen by 2 MB.

If I try and export to a CSV file it takes a while, seems done but the CSV
file cant be seen in the folder to which it was saved.

What's going? Why is the file size so large and wht cant I save?

Joel

--

Sammeg Satellite PTY Ltd
Po Box 43234
Industria
2042
South Africa
www.samsat.co.za
Tel +27114742666
Fax +27114742950
 
Open your spreadsheet and press CTRL-END and note where that takes your
cell focus. Excel accounts for things besides cells with data when
calculating thesize of the workbook.

I regularly receive files from coworkers where they have formatted
thousands of rows - without regard as to how that affect the size of
the file and the performance of Excel.

If Excel takes your cursor well beyond the cells, EDIT | CLEAR | ALL to
remove the formatting and contents and then immediately save the
document.
 
better yet dont use excel, it is bloatware.

i mean.. come on... get real-- why can't Microsoft fix this?

spreadsheets are WAY too big for everyday use and Excel is a disease
 
Back
Top