Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Incomplete Office 2007 install? Where are .NET PIAs for Excel? Need VSTO? John Brock Excel Discussion (Misc queries) 3 February 26th 09 06:21 PM
excell 2007 sbarfoote Excel Discussion (Misc queries) 1 January 3rd 09 04:50 PM
Excel 2007 formula recalculation DevTestPerson Excel Discussion (Misc queries) 1 November 28th 08 06:31 PM
How to open MS Excell 2007 Sheet in MS Excell 2000??? Alek Luchnikov New Users to Excel 1 March 22nd 07 05:40 PM
Excell 2007???? Gklass Charts and Charting in Excel 12 July 31st 06 02:19 PM


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"