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

markyliang · Feb 26th, 2002, 01:36 PM

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 · Feb 26th, 2002, 02:09 PM

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 · Feb 26th, 2002, 02:40 PM

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?

Feb 26th, 2002, 02:09 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 01:36 PM	#1
markyliang New Member Join Date: Feb 2002 Posts: 1	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

Feb 26th, 2002, 02:40 PM	#3
Helen Board Regular Join Date: Feb 2002 Posts: 103	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?