Excell 2007 SP1 - Incomplete recalculation
I have a spreadsheet that works fine in Excel 2003. However in Excel 2007
SP1 it often doesn't fully recalculate. When that happens, pressing F9 fixes it. The spreadsheet uses webqueries to download web page data. The webquery data downloads properly. The formulas which reference the webquery data via the name of the webquery range are the ones that very often do not recalculate (until I press F9). Here is an example of such a formula: =HLOOKUP(C$2,OFFSET(yfData,$E6-1,0),$E7+1,FALSE) yfData is the name of the webquery range ("Name" in Data Range Properties). E6 is =MATCH(D6,OFFSET(yfData,0,0,,1),0) E7 is =MATCH(D7,OFFSET(yfData,E6,0,,1),0) All other cells (C2, D6, D7) contain a text string (a constant, not a formula). Saving the spreadsheet in native Excel 2007 format does not fix the problem. Any help with this is appreciated! |
All times are GMT +1. The time now is 10:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com