A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Changing Source File of Linked Excel Charts



 
 
Thread Tools Display Modes
  #1  
Old August 3rd, 2004, 03:35 PM
Brad Bendecl
external usenet poster
 
Posts: n/a
Default Changing Source File of Linked Excel Charts

I have a PowerPoint file with a substantial number of embedded charts
and tables linked to Excel. The presentation needs to be updated
every quarter to reflect the most current data in the underlying Excel
file. However, instead of updating the same Excel source file every
quarter, I rename the source file after I've updated it with the most
current quarterly data. When I go into my PowerPoint file and attempt
to change the source of the links so that it maps to the most current
version of the Excel file, my table links update beautifully, but my
chart links don't update correctly. Any idea how to make the chart
links re-map correctly when the Excel source file is changed?
  #2  
Old August 3rd, 2004, 03:56 PM
Brian Reilly, MS MVP
external usenet poster
 
Posts: n/a
Default Changing Source File of Linked Excel Charts

I don't understand why you are renaming the original file and trying
to do all that extra work to repoint all the links.

A much simpler approach would be to just save the old XL file as a new
name and then update the data in the original file and all your links
would be intact. And you'd have time to go to the beach.

Brian Reilly, PowerPoint MVP
  #3  
Old August 4th, 2004, 02:51 AM
Brad Bendecl
external usenet poster
 
Posts: n/a
Default Changing Source File of Linked Excel Charts

Brian, I have done exactly what you suggested in other instances, but
I wanted to inquire as to whether there is actually a solution to this
problem that I haven't found yet on my own. If it simply doesn't
exist, I can live with that, but it would be helpful to know why
PowerPoint can successfully change embedded links to cell ranges in
Excel but not to charts in Excel. I find it very strange. I suppose
I'm secretly hoping for an easy fix, and I figured there would be no
harm in posing the question to the experts. Yes, I do agree that it
would be agonizing to go the through the process of relinking, but
frankly that would be considerably less painful than the confusion I'm
bound to stir up among my co-workers by changing file naming
conventions. Plus there isn't a good beach within 200 miles of here
anyway. :-)

Thanks


"Brian Reilly, MS MVP" wrote in message . ..
I don't understand why you are renaming the original file and trying
to do all that extra work to repoint all the links.

A much simpler approach would be to just save the old XL file as a new
name and then update the data in the original file and all your links
would be intact. And you'd have time to go to the beach.

Brian Reilly, PowerPoint MVP

  #4  
Old August 4th, 2004, 08:44 AM
Kurt
external usenet poster
 
Posts: n/a
Default Changing Source File of Linked Excel Charts

Brad,
You could also have a look at www.take-off.as/datapoint
Kurt

"Brad Bendecl" wrote in message
m...
Brian, I have done exactly what you suggested in other instances, but
I wanted to inquire as to whether there is actually a solution to this
problem that I haven't found yet on my own. If it simply doesn't
exist, I can live with that, but it would be helpful to know why
PowerPoint can successfully change embedded links to cell ranges in
Excel but not to charts in Excel. I find it very strange. I suppose
I'm secretly hoping for an easy fix, and I figured there would be no
harm in posing the question to the experts. Yes, I do agree that it
would be agonizing to go the through the process of relinking, but
frankly that would be considerably less painful than the confusion I'm
bound to stir up among my co-workers by changing file naming
conventions. Plus there isn't a good beach within 200 miles of here
anyway. :-)

Thanks


"Brian Reilly, MS MVP" wrote in message

. ..
I don't understand why you are renaming the original file and trying
to do all that extra work to repoint all the links.

A much simpler approach would be to just save the old XL file as a new
name and then update the data in the original file and all your links
would be intact. And you'd have time to go to the beach.

Brian Reilly, PowerPoint MVP



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL TO OUTLLOK Woodsmith General Discussion 0 July 6th, 2004 12:29 AM
Bar Charts created in Excel 2003 - font resizes when file is reopened Lucie Harris Charts and Charting 0 June 16th, 2004 05:56 AM
#Num! in linked Excel file Dkline Database Design 4 April 27th, 2004 08:57 PM
Error opening an excel file from explorer Wah Setting up and Configuration 3 February 17th, 2004 04:28 PM


All times are GMT +1. The time now is 03:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.