Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet refresh time. . .
Using this formula to obtain latest prices from a spreadsheet
containing 21500 rows of data =INDEX(B4:B22000,MATCH(J4,A4:A22000,0)*MATCH(MAX(I F(A4:A22000=J4,C4:C22000)),C4:C22000,0)) It works well, but it's refresh/calculation time can border on 10-12 minutes. Any ideas on using these types of formulas; or methods to speed up the refresh process? (2 gig ram, 2.4 Mhz, and not alot of windows open.) Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically refresh the time on a worksheet? | Excel Discussion (Misc queries) | |||
Refresh an excel spreadsheet on a scheduled basis | Excel Discussion (Misc queries) | |||
Refresh Data in Excel Spreadsheet | Excel Discussion (Misc queries) | |||
I cannot refresh all of the queries in my spreadsheet | Excel Discussion (Misc queries) | |||
Large spreadsheet - Charts don't refresh | Charts and Charting in Excel |