How do I update copy of worksheet
 

Is there a way to update a copy of a spreadsheet(2 worksheets of 4 on
source) without manually opening the copy and updating the links?

How do I update copy of worksheet
 

If I am understanding your question correctly, then when changing links,
you should be prompted when re-openning the file to "Update Links" (yes,
no).


--
wmaughan
------------------------------------------------------------------------
wmaughan's Profile: http://www.excelforum.com/member.php...o&userid=29743
View this thread: http://www.excelforum.com/showthread...hreadid=493284