Excell 2007 SP1 - Incomplete recalculation

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top