large worksheet sluggish

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

I am running Win XP Pro SP1, and Office 2K. The pc has a
2 Ghz P4, w/512 MB DDR Ram.

I have a large spreadsheet (approx 35 MB) that takes
forever to open up or to make changes to. I just
increased the Ram from 512 MB to 1 GB. The worksheet
works exactly the same, no improvement.

Do I need to tell XP or Excel I have more memory available?

Thanks,
Jeff
 
Try this Jeff and see if it will make your file size smaller.

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close and try again

Don't save the file in two versions but only as Microsoft excel workbook
Not as 97-2002 & 5.0/95 workbook(this make your workbook big)

You can use Rob Bovey's Code cleaner to clean up your code
http://www.appspro.com/utilities/utilities.asp


See also this links

Opening/Saving Bottlenecks (Charles Williams)
http://www.decisionmodels.com/optspeedd.htm#OpSave

Troubleshoot Startup Problems(MS):
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280504

Some tips on overcoming slow response (David McRitchie)
http://www.mvps.org/dmcritchie/excel/slowresp.htm
 
Back
Top