I tried at home (Excel 2007), and it didn´t work too.
Hmm,
I've tested it in 2007 and it works fine for me (thanks also sous2817 for confirming it works for you).
Do you get the same error in 2007 as you did in 97, or does it not work for a different reason?