Paste Link Issues

[railfan1975]

I have a workbook with several worksheets in it. I am copying and pasting links from several sheets into a single summary sheet in the same workbook. Everything will be working fine and then all of a sudden, Excel will tell me it cannot paste the link. It will only do this when trying to paste link for a range, not individual cells. However, here's the odd thing. If I change the name of the worksheet I am copying from, the paste link will work. I can then change the name of the worksheet back to what it was and paste link will quit working again.

Has anyone ever had this happen to them? What's the fix?

Thanks!

JT