I would select the range to fix and then
edit|Replace
what: 2007
with: 2008
replace all
and
what: 07
with: 08
replace all


If there was a chance that the 2007 showed up in other places in the formula,
I'd try to give the edit|replace more info:

Edit|replace
what: 2007.xls]jan 07
with: 2008.xls]jan 08
replace all



rob_t wrote:

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




--

Dave Peterson