Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Update of Excel source (Office 2000)

    I have a PPT with various charts that have the data sheets linked to an Excel sheet. When I open it and select yes to update the links, the Excel charts in the PPT are updated, but not the data sheets for the PPT charts. I have to manually open each data sheet and update the data. Does anyone know of a way to update the data sheets when the links are updated as well? Is there another way to update them automatically? The links are set for automatic. Also, the cell formats are set to number with 1 decimal position, after the data sheet is refreshed, the formats are set to general. Anyone know how to keep the as numbers? Thanks.

  2. #2
    New Lounger
    Join Date
    Mar 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Update of Excel source (Office 2000)

    Never mind, I found this link http://support.microsoft.com/search/previe...b;en-us;Q222689. Now I just have to figure out how to keep the cell formatting.

Posting Permissions

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