Excel - weeknum giving error on one workbook but not another

[owentmoore]

Hi all

I am having an anoying little problem. I am using weeknum to return the current week number. Problem is that I am getting the error "That name is not valid". I have Analysis Toolpak installed.

When I create a new workbook and use the weeknum formula it works perfectly!

Any ideas what is happening?

Thanks
Owen

 

[SkipVought]

Hi,

"...I am getting the error "That name is not valid".

Not on a spreadsheet.

Please post in forum707

Skip,

_[red][/red]

 

[owentmoore]

Skip - i've reposted.