I have the same issue as you do. I have an excel file that is an excel 97/2003 file. Some people open the file in excel 2007. The calculation (formula) sometimes disappears and becomes =#NA. In that cell i just have =weeknum(A1).
Does anyone know why the formula gets replaced? This is reallly a pain because i have to put back the formula
GMc wrote:
Weeknum Issue
14-Jun-08
I have a 2003 .xls file that I run on 2007, there is a formula in th
file that uses the =weeknum(c2) formula. I am getting an issue wher
excel is removing this formula and replacing it with =#n/a, whic
means I have to go in and add the formula again
This is not the first time this has happened, I had another completel
independant file where the same thing happened with the weeknu
formula
A couple of thing
1) does anyone know whats going on
2) is there any other easy way to extract a workweek from a dat
without using this formula
Thank
GMc
Previous Posts In This Thread:
Re: Weeknum Issue
Hallo GM
Zie deze pagin
http://office.microsoft.com/nl-nl/excel/HA102581001043.asp
En oo
http://www.rondebruin.nl/atp.ht
-
Regards Ron de Brui
http://www.rondebruin.nl/tips.htm
Re: Weeknum Issue
Oops, this is no Dutch group <g
Hi GM
See this pag
http://msdn.microsoft.com/en-us/library/bb277364.asp
Or the pages on my sit
http://www.rondebruin.nl/isodate.ht
An
http://www.rondebruin.nl/weeknumber.ht
And als
http://www.rondebruin.nl/atp.ht
--
Regards Ron de Brui
http://www.rondebruin.nl/tips.ht
Weeknum Issue
I have a 2003 .xls file that I run on 2007, there is a formula in th
file that uses the =weeknum(c2) formula. I am getting an issue wher
excel is removing this formula and replacing it with =#n/a, whic
means I have to go in and add the formula again
This is not the first time this has happened, I had another completel
independant file where the same thing happened with the weeknu
formula
A couple of thing
1) does anyone know whats going on
2) is there any other easy way to extract a workweek from a dat
without using this formula
Thank
GMc
Submitted via EggHeadCafe - Software Developer Portal of Choice
Adding WCF Service References
http://www.eggheadcafe.com/tutorial...9-dfa51a9fab8e/adding-wcf-service-refere.aspx