Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Exeter, New Hampshire, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking with Excel (Office 2K SR-1)

    Hi,
    I'm wondering if it's possible to link PP charts to Excel data sheets so that they get updated automatically.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Linking with Excel (Office 2K SR-1)

    Yes. Copy the data in Excel in the usual way (of course, the Excel file must be saved first for this to work). Switch to PPT. Open up the datasheet for your chart. Select the entire chart by clicking on the top left hand corner (see picture).
    Click on the Edit menu and choose Paste Link
    A MS Graph message will pop up asking you if you want to replace the data in the data sheet - Click on OK
    Tada! Your info is linked!

    Now if you go to the Edit menu, you'll find the Links choice is now active. There are some useful options in this dialog box.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Exeter, New Hampshire, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking with Excel (Office 2K SR-1)

    Is there a way to update all the linked charts in PPT automatically instead of one at a time? The linking process you suggested worked brilliantly but the charts only seem to be updated when I doubleclick on them, even though the linking is set to Automatic. I expected to get a message as I opened the PPT file asking me if I wanted to update the document.

    Thanks

  4. #4
    3 Star Lounger
    Join Date
    Dec 2002
    Location
    USA
    Posts
    397
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking with Excel (Office 2K SR-1)

    You might check under Edit/Links and see if those are listed. If so, you should be able to update them all at once.

Posting Permissions

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