WEEKNUM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Maiden - 21 Jul 2003 19:36 GMT

My spreadsheet that was used on Windows 95 sucessfully
has a problem in Windows XP Professional with the WEEKNUM
function.

I get an error #NAME? instead of the week number. Its
been working for a few years now but not with Windows XP
Pro anymore.

Yours faithfully

Mark Maiden

Reply to this Message

Rob Bovey - 21 Jul 2003 19:52 GMT

Hi Mark,

The WEEKNUM function requires the Analysis Toolpak add-in to be loaded.
Choose Tools/Add-ins from the Excel menu and put a check mark beside the
entry called Analysis Toolpak (not Analysis Toolpak - VBA). If you don't see
this entry you'll need to install it using your original installation disks.

Signature

Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

> My spreadsheet that was used on Windows 95 sucessfully
> has a problem in Windows XP Professional with the WEEKNUM
[quoted text clipped - 7 lines]
>
> Mark Maiden

Reply to this Message

Mark Maiden - 21 Jul 2003 20:44 GMT

Dear Rob
Yeh! That did the job. Now I can enter Week Numbers again
[I added Analysis Toolpak]

Many thanks

Mark

>-----Original Message-----
>Hi Mark,
[quoted text clipped - 17 lines]
>
>.

Reply to this Message