Paste Link problems with EXCEL 2007
 

When I copy selected cels from the source workbook to the destination
workbook using Paste Link the operation appears to work fine, however it also
renames all of the tabs in the source workbook to Chart 1, Chart 2, etc.
forcing me to change them again. I also noticed that if I opened the
destination workbook first it would rename the tabs if I then opened the
source workbook. This is a problem because I am trying to condense data from
10 workbooks with about 20 worksheets.

Is anyone else having this problem? Is there a known fix? I have tried
every day to get the latest updates to Office EXCEL 2007 but so far there
aren't any.