|  | refresh links | | |
| | | herbslc |  |
|  Posted: Thu Aug 28, 2008 11:43 am Post subject: refresh links |  |
Running Powerpoint 2007 i have multiple charts that are linked to excel
spreadsheets. i need powerpoint to automatically refresh. from the posts i
have read, there should be a button from start, microsoft office, prepare,
then edit links. i have prepare, but there is no such choice for edit links.
additionally, when i click on the chart, the refresh data icon doesn't work.
the only way i can get the data to refresh is to open each chart's data
manually.
what am i doing wrong??? |
| |
| | | John Wilson | |
| | Posted: Thu Aug 28, 2008 12:25 pm Post subject: RE: refresh links | |
After choosing "Prepare" scroll down ( hover over blue arrow) and see if that
helps.
--
Amazing PPT Hints, Tips and Tutorials
LINK
email john AT technologytrish.co.uk
"herbslc" wrote:
| Quote: | Running Powerpoint 2007 i have multiple charts that are linked to excel
spreadsheets. i need powerpoint to automatically refresh. from the posts i
have read, there should be a button from start, microsoft office, prepare,
then edit links. i have prepare, but there is no such choice for edit links.
additionally, when i click on the chart, the refresh data icon doesn't work.
the only way i can get the data to refresh is to open each chart's data
manually.
what am i doing wrong??? |
|
| |
| | | herbslc | |
| | Posted: Thu Aug 28, 2008 12:34 pm Post subject: RE: refresh links | |
nope, my choices under prepare are
properties, inspect, encrypt, restrict, add digital.., mark as final, run
compatibility
"John Wilson" wrote:
| Quote: | After choosing "Prepare" scroll down ( hover over blue arrow) and see if that
helps.
--
Amazing PPT Hints, Tips and Tutorials
LINK
email john AT technologytrish.co.uk
"herbslc" wrote:
Running Powerpoint 2007 i have multiple charts that are linked to excel
spreadsheets. i need powerpoint to automatically refresh. from the posts i
have read, there should be a button from start, microsoft office, prepare,
then edit links. i have prepare, but there is no such choice for edit links.
additionally, when i click on the chart, the refresh data icon doesn't work.
the only way i can get the data to refresh is to open each chart's data
manually.
what am i doing wrong??? |
|
| |
| | | Eric Schmidt | |
| | Posted: Fri Aug 29, 2008 7:01 pm Post subject: RE: refresh links | |
| |  | |
First: I believe that the link/file path between an Excel spreadsheet and a
cut & pasted graph in a PowerPoint slide are relational.
So, have you moved the Excel file's location to another folder? (I doubt
that's the case given your second issue...)
Second: no "Edit links" on "Prepare" - after tinkering around, it seems to
me that if you don't see that "Edit Links" button on "Prepare," it means that
there isn't any linked data in your presentation.
If you created the graph, THEN cut & pasted it into PPT, and THEN saved the
Excel spreadsheet, then PowerPoint won't consider it a "linked" graph.
But after re-reading your posts, another thought occurred to me: did you
create these graphs in Excel, or did you click on the "Insert Chart" button
in PPT?
--
Eric Schmidt, Microsoft User Assistance
"herbslc" wrote:
| Quote: | nope, my choices under prepare are
properties, inspect, encrypt, restrict, add digital.., mark as final, run
compatibility
"John Wilson" wrote:
After choosing "Prepare" scroll down ( hover over blue arrow) and see if that
helps.
--
Amazing PPT Hints, Tips and Tutorials
LINK
email john AT technologytrish.co.uk
"herbslc" wrote:
Running Powerpoint 2007 i have multiple charts that are linked to excel
spreadsheets. i need powerpoint to automatically refresh. from the posts i
have read, there should be a button from start, microsoft office, prepare,
then edit links. i have prepare, but there is no such choice for edit links.
additionally, when i click on the chart, the refresh data icon doesn't work.
the only way i can get the data to refresh is to open each chart's data
manually.
what am i doing wrong??? |
|
| |
| | | Steve Rindsberg | |
| | Posted: Mon Sep 01, 2008 3:56 pm Post subject: Re: refresh links | |
| | | |
In article <B910CB2C-EB12-4821-BF74-9E3DA6D4F8B5@microsoft.com>, Herbslc wrote:
| Quote: | Running Powerpoint 2007 i have multiple charts that are linked to excel
spreadsheets. i need powerpoint to automatically refresh. from the posts i
have read, there should be a button from start, microsoft office, prepare,
then edit links. i have prepare, but there is no such choice for edit links.
additionally, when i click on the chart, the refresh data icon doesn't work.
the only way i can get the data to refresh is to open each chart's data
manually.
|
If you created the charts using Insert, Chart in PPT2007, they're not linked
charts, so there's no link to edit.
If that's not the case, how exactly did you insert the charts?
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: LINK
PPTools: LINK
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
LINK |
| |
|
|
