J
JimT
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!
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!