Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function dosn't work in Excel 2007 but did in 2003
I have a worksheet which was created in Excel 2003. after upgrading to 2007
it containes a function =number.workingdays(A1;A2) which dosn't work. If I open the worksheet in 2007, and dobbelt click on the function then it works. Is there something I have to change in the settings, so the function works automatically? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function dosn't work in Excel 2007 but did in 2003
That doesn't look like the name of a function in my USA version of xl2003.
But it could be a difference in installed versions (language) or it could mean that you're using an addin that isn't available in xl2007. It may help if you include the language of excel for both your xl2003 and xl2007 versions. In xl2003 (USA version), there's an =networkdays() function and an =workday() function. Both of these are part of the analysis toolpak in xl2003, but they're built into xl2007 proper. Harding wrote: I have a worksheet which was created in Excel 2003. after upgrading to 2007 it containes a function =number.workingdays(A1;A2) which dosn't work. If I open the worksheet in 2007, and dobbelt click on the function then it works. Is there something I have to change in the settings, so the function works automatically? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel 2007 work like 2003 | New Users to Excel | |||
Since updating Office 2003 to 2007 Excel formulas do not work? | Excel Discussion (Misc queries) | |||
Opening Excel 2003 file in Excel 2007: Links do not work | Excel Discussion (Misc queries) | |||
I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions | |||
Embedded Excel 2003 spreadsheet in web page won't work with Excel 2007 | Excel Discussion (Misc queries) |