Huge sheet for no reason

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
 
C

comish4lif

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.
 
A

aaron.kempf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top