I have programmatically created a workbook.

Several cells have a .Formula inserted of the form

=XIRR(B47:B49,A47:A49)

Which looks valid to my olde eyes.

However, when I manually open the workbook:

1. All cells with an XIRR are flagged as #NAME? (TH eAnalysis Tool Pack is
loaded).
2. If I select a cell with an XIRR, then select the forula in the formula
bar, then use Enter, the forulma
is calculated, so there is nothing wrong with the formula.

What's the workaround?