Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to update functions in excel sheet?
Sirs, I prepared an excel sheet and used functions to convert dates into
numbers then convert these numbers into week number allover the calender year. then without any reason, all my sheets showed an error in the cells containing the mentioned formulas and the name of the formulas itself disappeared from the functions list available in excel. it's really urgent to know ur answers, because I am preparing reports using the week number. if this case lasts for long, I'd be wasting much time. Kindly reply as soon as possible. Regards |
#2
|
|||
|
|||
Assuming you used the WEEKNUM Function there most likely is "a reason".
You must have the Analysis Toolpak add-in loaded for this function to work. ToolsAdd-ins. Check the ATP. Gord Dibben Excel MVP On Tue, 22 Feb 2005 00:39:04 -0800, "Inass" wrote: Sirs, I prepared an excel sheet and used functions to convert dates into numbers then convert these numbers into week number allover the calender year. then without any reason, all my sheets showed an error in the cells containing the mentioned formulas and the name of the formulas itself disappeared from the functions list available in excel. it's really urgent to know ur answers, because I am preparing reports using the week number. if this case lasts for long, I'd be wasting much time. Kindly reply as soon as possible. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use variables for workheet name references in Excel functions? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Worksheet Functions | |||
Am not getting "send" option to email Excel sheet | Excel Discussion (Misc queries) | |||
How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions | |||
hyperlink to specific sheet in excel | Excel Worksheet Functions |