Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Thanked 0 Times in 0 Posts

    Excel Chart copying

    Help! I have added new sheets to an excel workbook and copied templates that are existing sheets in the workbook to the new sheets. The existing sheets had some bar charts on them and now that I have copied them to the new sheets, I have a problem. When I try to change the source data series on the charts on the new sheets, I get a window telling me that there is not enough memory; however, when I try to change the source data series on the charts on the old sheets, I have no problems. I can't figure out what's wrong!!!

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post

    Re: Excel Chart copying


    I guess the Charts are pointing to the old workbook. Try and do a Find and replace.

    1) save the workbook.
    2)Close all windows.
    3) Restart your PC
    4) Close all windows/applications that started.
    5) Launch Excel all by it self.
    6) Open the workbook in question and do the find and replace.

    Make sure you have all the names that you had in the old workbook.

    Good luck and may the force be with you.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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