Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incomplete Office 2007 install? Where are .NET PIAs for Excel? Need VSTO? | Excel Discussion (Misc queries) | |||
excell 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 formula recalculation | Excel Discussion (Misc queries) | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
Excell 2007???? | Charts and Charting in Excel |