locked
WEEKNUM function in Excel 2003 does not work in Windows Developer Preview

    Question

  • Have a spreadsheet in Excel 2003 containing the WEEKNUM function.  In Windows 7, the function works properly.  In Windows Developer Preview the "#NAME?" value is returned.  This has been retested on Windows 7 and in Windows Developer Preview the problem was replicated by entering "=WEEKNUM(Date(2011,10,05))"
    Thursday, October 06, 2011 12:13 AM

Answers

  • The problem was found to be that the "Analysis Pak" was not installed as an add-in.  Installed the add-in and it works fine now, no additional feedback will be provided.
    • Marked as answer by KLawson419 Tuesday, October 11, 2011 9:33 PM
    Tuesday, October 11, 2011 9:32 PM

All replies

  • Hey KLawson419,

     

    Thank you for posting your feedback, we want to make sure we get the right info including your log files. Can you also submit feedback using the Windows Feedback Tool from the Connect Site associated with your Windows Developer Preview program? If you’re an MSDN subscriber, the information on how to join the Connect program is included on the download page where you installed Windows Developer Preview. There’s a link to the Connect site and an invitation code that you can click on to join using a Windows Live ID account. If you’re not an MSDN subscriber follow this limited use link to join the Connect program and then follow the steps here.


    Steven
    Saturday, October 08, 2011 10:54 PM
    Moderator
  • The problem was found to be that the "Analysis Pak" was not installed as an add-in.  Installed the add-in and it works fine now, no additional feedback will be provided.
    • Marked as answer by KLawson419 Tuesday, October 11, 2011 9:33 PM
    Tuesday, October 11, 2011 9:32 PM