Excel gurus please help me! Copy charts to a different file
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com