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))"

Answer 1

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

Answer 2

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.