link to Excel doesn't hold

M

MeredithS

I'm linking an Excel chart to a PowerPoint slide (actually, 20 of them); the
charts each come from workbooks with worksheets for: Data, Chart, Legend,
etc. I link directly to the chart, but when I update it the following month,
what's visible in PowerPoint is the Data sheet of the underlying workbook.
I've tried working around it by putting the Chart sheet 1st in the queue but
that doesn't help ...

Suggestions?

Thanks,

Meredith
 
B

Brian Reilly, MVP

Meredith,
How are you updating the links the next month? Thought the menu Edit +
Links plus update, or are you doubleclicking the chart itself inside
of PPT?

Brian Reilly, MVP
 
M

MeredithS

I'm updating the links apparently automatically -- when I open the PP
presentation, it asks if I want to update the links. Regardless of whether I
say yes or no, PowerPoint will display mostly the datasheets. Occasionally,
some of the slides will display the chart, as I wish, but since I'm not doing
anything different, I don't know how that's happening. And, it doesn't seem
reliable...

Each month, I'm updating the datasheets and charts in Excel, then I try to
close the file with the chart sheet open -- that doesn't seem to help, though.

?

Thanks,

Meredith
 
M

MeredithS

I haven't tried that and will do so, but do I need to be doing anything
specific in the underlying Excel files? What I have been doing is updating
the data and charts monthly, then closing the Excel file with the chart
displayed at the time I close it -- doesn't seem to help, though.

?

Thanks,

Meredith
 
B

Brian Reilly, MVP

Meredith,
That is odd behavior indeed. If you want to email me a small sample
that doesn't work, I'll take a look at it here. Take the Not out of my
email address.
Brian Reilly, MVP
 
Top