Hi,
I have a number of financial calculations that are to be performed for a
list of dates where the result is dependent on the input date.

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