Excel Files Grows Huge

  • Thread starter Thread starter Dave Evans
  • Start date Start date
D

Dave Evans

I have Excel 2000 and created a standard data workbook
with three worksheets. Cells are either general verbage
(name, address, etc.) or $ amounts with certain columns
added together. I use columns A to AA and have 789 rows
of entry. The data file has suddenly grown to 7.5 Meg and
is impossible to work with. Entries made over the last
150 rows seem to have slowed everything down. Any ideas
what is wrong?
 
Dave Evans said:
I have Excel 2000 and created a standard data workbook
with three worksheets. Cells are either general verbage
(name, address, etc.) or $ amounts with certain columns
added together. I use columns A to AA and have 789 rows
of entry. The data file has suddenly grown to 7.5 Meg and
is impossible to work with. Entries made over the last
150 rows seem to have slowed everything down. Any ideas
what is wrong?
Click to expand...

Maybe something (even just a space character or cell format) has got into a
cell way beyong your real data range. Use Ctrl+End to see where Excel thinks
the last used cell is on each worksheet. If it is way beyond where it should
be, select all rows below your data and delete (using Delete on an Edit
menu, not the Delete key on the keyboard). Repeat for columns to the right
of your data. Save the workbook (and on early versions, close and relaunch
Excel). Your file size will be much smaller and will work faster.
 
Back
Top