My excel file is too large (5 mb) when it shouldn't be, why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel file has ballooned in size for some reason. I have tried to
copy all the cells and then used "paste special" to paste just the values and
the file size doesn't reduce. I am copying numbers from an investment
website into my spreadsheet and there don't appear to be any issues with the
pasted cells but I suspect it is causing the file size expansion and very
slow performance. I then deleted all the cells around by spreadsheet and it
didn't help at all.

All suggestions as to how I can fix this problem appreciated.

Kenview
 
If you do a Ctl-End, does it take you out in the "weeds"?
If it does, delete the rows and columns and immediately save the workbook.
In some versions of xl you have to then close the book after this action in order for xl
to reset its last cell IIRC.
 
You must log in or register to reply here.

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

Similar Threads

dropdown boxes make file size too large 2
my excel file is too big 1
Paste Special Values 2
Linking problems in Excel 2007 2
Is my file corrupted? 3
Large Excel 2008 .xlsx file behaviour with Vista 3
Large file sizes after modifying spreadsheet in Excel 2007. 3
Very Large Files 3

Back
Top