Good Morning -
Using Windows XP SP3 and Excel 2010.
I've setup a template that will automatically insert a date/time stamp using a circular reference formula with NOW(). I have the override selected and everything works perfect.
However, I need to put this out on a shared drive and have others use it.
Is there a way to basically "globally" override the settings to allow them all to use this without each individual having to go through and change that setting?
I'm using this formula in case someone thinks there is a better way. Prefer to avoid macros since a lot of our users have it drilled into thier heads never to allow macros to run (We have 20k+ employees so it's a LOT safer that way
)
Thanks as always. I've learned so much here!
Using Windows XP SP3 and Excel 2010.
I've setup a template that will automatically insert a date/time stamp using a circular reference formula with NOW(). I have the override selected and everything works perfect.
However, I need to put this out on a shared drive and have others use it.
Is there a way to basically "globally" override the settings to allow them all to use this without each individual having to go through and change that setting?
I'm using this formula in case someone thinks there is a better way. Prefer to avoid macros since a lot of our users have it drilled into thier heads never to allow macros to run (We have 20k+ employees so it's a LOT safer that way
)
Code:
=IF(A2<>"",IF(D2="",NOW(),D2),"")Thanks as always. I've learned so much here!
