View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Slow Excel Help please?

The following site (See Contextures URL below) has instructions on resizing
the used range in a worksheet.

If your problem is caused by formerly used rows or unused rows that have
been formatted, this will fix the problem.

You'll have to apply this to all worksheets in your workbook.

http://www.contextures.com/xlfaqApp.html#Unused

--
Kevin Backmann


"Terry" wrote:

Hi group.

Win XP SP2
MS Office 2003

Recently I have notice a workbook in excel takes MUCH longer to open now,
yet I have not added much data to file...I am able to open a new excel sheet
with no problem.

My PC is up to date with Windows updates, and wonder if an update may have
caused above problem.

I do regular house keeping on my PC...defrag. cleanup, antivirus checks etc.
etc.

Size "on disc" of above file is 192KB.
The file is OK once opened.

TIA

Terry