View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default ? How to enable functions that stopped computing after XP SP3 upda

"Weeknum" requires the Analysis ToolPak to be installed & activated*

Chip Pearson's page has details on the "Analysis Toolpak" at:
http://www.cpearson.com/excel/ATP.htm

*Check the "Analysis Toolpak" box via Tools Add-Ins
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Ev Shafrir" wrote:
-- example: WEEKNUM stopped working;
-- simple numeric calculations work; (calculate switched to 'auto'
-- YEAR function works (with the auto yellow syntax hint)


?? what gives ??
?? is there a function pack to reload or re-enable ??

Using: Excel 2003 (Office 2003)