Hi Anand,

It ought to work that way and it's a good way to do it.
Are you sure the data in your table depends on something that has been
changed? Do you not have any User Defined Functions that take data from
sheets directly instead of via arguments?
Sometimes (but very, very rarely) Excel loses track of dependencies. You can
rebuild the dependency tree by pressing CTRL+ALT+SHIFT+F9.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Anand" wrote in message
...
Hi,
I had posted this question in the General section but thought that it may
be
more appropriate here ...

I have a number of financial calculations that need to be repeated for a
list of dates where the result is dependent on the input date. I need the
results form all these dates for other calculations in the spreadsheet.

I have set the calculation to manual since the spread sheet is quite large
and use F9 to recalculate.

I used the Data - Table function to repeat the calculations for the set of
dates. However, the Table does not recalculate when I hit F9. The bottom
left portion of the Excel window says "TABLE" when I hit F9, which I guess
means that the Table has not re-calculated. I have to go the the sheet
that
contains the Table and hit Shift-F9 to force the Table to recalculate.

How can I force the Table to recalculate when I hit F9, or is there a
better
way to perform a repeating loop in Excel?

Thanks

Anand