WEEKNUM

M

Mark Maiden

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
 
R

Rob Bovey

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.

--
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 *
 
M

Mark Maiden

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

Many thanks

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top