thanks max eg following='C:\Users\Robert\Documents\Robert\Budget \[Visa
2007.xls]Jan 07'!C51 I need to update to 2008

"Max" wrote:

Maybe you could post a sample or two of your "hardcoded" formula for a
better answer?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rob_t" wrote in message
...
I have a spreadsheet with date references repeatedly used in the formula. I
wish to change the formula from 07 to 08 and not have to manually change
in
every cell it appears