View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mckzach mckzach is offline
external usenet poster
 
Posts: 10
Default Filtered spreadsheet performance

Hi, all

I've got a filtered spreadsheet constructed of about 40 columns and less
than 2000 rows of data. At times, the file runs very smoothly and delivers
accurate results. At other times, the spreadsheet is unusually slow;
sometimes taking a couple of minutes for it to calcuate the desired results.

Is there anything I can do (or un-do) that will speed up the time it takes
to process results? I'm not sure why it hangs up, and/or if there's any one
thing that is to blame.

Any/all suggestions are welcomed.

Thanks!