werafa
04-02-2013, 10:07 PM
Hi all,
I have a template I paste excel charts into for a presentation. If I change a chart after pasting, it updates itself, and I want to stop this behavior.
I have found a 'break links' function on the file tab that you can navigate to and break each link after pasting, but find this a rather ordinary way to work.
Is there a way to force ppt to not refresh external data automatically (The break links tab says it is on manual update, but helpfully changes things anyway).
Alternatively, I run some code every time I paste a graph - what is the vba to toggle the external data link for the active shape/graph?
Thanks
Tim
I have a template I paste excel charts into for a presentation. If I change a chart after pasting, it updates itself, and I want to stop this behavior.
I have found a 'break links' function on the file tab that you can navigate to and break each link after pasting, but find this a rather ordinary way to work.
Is there a way to force ppt to not refresh external data automatically (The break links tab says it is on manual update, but helpfully changes things anyway).
Alternatively, I run some code every time I paste a graph - what is the vba to toggle the external data link for the active shape/graph?
Thanks
Tim