Excel gurus please help me! Copy charts to a different file

[markyliang]

Hi, I am Excel 97 user.
I am trying to copy a bunch of worksheets with charts from one excel file to another excel file. But in the copied worksheets, the charts formula range refer back to the old file. Is there any way I can get them pointing to the current file?

Thanks,
Mark Liang

 

[Juan Pablo González]

When you finish copying the sheets and charts, go to Edit, Links and click on "Change Source". Then, select your "current" file. That should work.

 

[Helen]

Sorry to not help answer the question, but what about when you are copying from one worksheet to another, this keeps the links to the original worksheet instead of copying them to the new worksheet.

Is there anyway to change this too?