Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtered spreadsheet performance
I have a similar problem. For me, it is almost always related to links to
external files. If you have those files open when you start it should help cut down on the processing type. Another issue is complex formulas. I find it helpful to change the calculation mode to Manual until I need an explict recalc done. Hope this helps. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "mckzach" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performance Spreadsheet (Rates of Return) | Excel Discussion (Misc queries) | |||
Alternate row shading with a filtered spreadsheet | Excel Discussion (Misc queries) | |||
Copying filtered data to another Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet performance is slow | Excel Worksheet Functions | |||
Prevent A Macro From Running If SpreadSheet is Filtered | Excel Worksheet Functions |