Use find and replace file name

"Ron de Bruin" wrote:

Hi vcff

Try EditLinks in the menu bar if your Excel version have that option

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vcff" wrote in message ...
"File1_2006.xls" is data input file (one year record)
"File2_2006.xls" is display file (extract info from above file) and contains
50sheets to display info by using =C:\[file1_2006.xls]details'!A1
=C:\[file1_2006.xls]details'!A2
=C:\[file1_2006.xls]details'!B5
........
........
=C:\[file1_2006.xls]details'!A10

For the year 2007, I delete all the info in "File1_2006.xls" and rename it
as "File1_2007.xls".
I also save "File2_2006.xls" under new file name "File2_2007.xls".

However, all the formulas in "File2_2007.xls" still link to "File1_2006.xls"
and is there a way where I can make all the formulas in "File2_2007.xls" to
link to "File1_2006.xls".

Or is there a better way to do it, 1 file for input and the other to display
info extract from the first .

Thanks