I have several wookbooks that get data from others. I went in to find &
replace 08 in the formulas to 09. First one went fine but second one stopped
half way thru the replace and gave me a box that said update values:
April'09.ar.xls and it is asking me for a file name. Not sure what file name
it was looking for, anything I put in is not accepted and it will not let me
cancel ot X out of the window. the April'09.ar.xls is not the file I was
finding & replacing in but a file that links to the one.