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?
|