Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weeknum-function
Hello,
one of the users, using my excelfile gets #NAME? instead of the hyperlink and the link doesn't work for her (it works fine for every other user). The formula is =HYPERLINK("#Planerat!R2C"&(WEEKNUM(NOW())-11); "Conversion") I checked that she has the Analysis TollPak selected, because I suspect that that is where the problem occurs, because in another cell I am showing what week we have right now and that cell is also #NAME? for her. Anyone knows what might be the problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weeknum function help | Excel Worksheet Functions | |||
Weeknum function | Excel Discussion (Misc queries) | |||
WEEKNUM Function | Excel Worksheet Functions | |||
Weeknum Function | Excel Worksheet Functions | |||
WeekNUM Function | Excel Worksheet Functions |