Errors in named formulas after running macros
 

Lectori salutem,

In an Excel 2002 workbook I have named formulas, e.g. WeekNumber,
defined (while in cell A2) as
=1+INT((!A1-DATE(YEAR(!A1+4-WEEKDAY(!A1+6));1;5)+WEEKDAY(DATE(YEAR(!A1+4-WEEKDAY(!A1+6));1;3)))/7)
(Thx2 Chris Pearson and Evert van den Heuvel)

It calculates the weeknumber of the date in the cell directly above the
cell containing the formula.
Now whenever I run a macro like J.E. McGimpsey's ListFormulasInWorkbook
(see <http://www.mcgimpsey.com/excel/listfunctions.html)
the formula results in an error like #VALUE! or #NUM! or even #REF!
Mind you, the formula itself is not the problem, the same occurs with
other even trivial named formula's.
Using <F2 followed by <Enter corrects the error, but in my actual
application I have hundreds of named formula occurrences like these.
Does anyone recognize this behaviour and what is the solution for it?

Any help would be much appreciated!!