Hi Tommy
Go to Edit Links and link the book to itself.

Thanks
Barb

"TommySzalapski" wrote:


I am building a report creator which creates a new workbook for the data
every fiscal week. The problem is, when I copy a worksheet to the new
workbook from the template workbook the references still point to the
old workbook (i.e. =Data!B3 becomes =[Audits.xls]Data!B3) is there some
easy way to prevent this? I used the replace method to remove all the
["oldFileName"] instances but this is clumsy.

Thanks,
Tommy


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=389934