Hello guys,
first off not sure if here is the place for this issue, so pls direct me if I'm on the wrong street
Straigth to the point >_> I got some 80ish slides with diagrams all of which are linked to an Excel book with several spreadsheets. When I have the master excel book and the temporal spreadsheet for the respective diagram everything is fine.
But if I change something on the spreadsheet, then all the 80 diagrams should be refreshed. I don't want to be opening them one by one (lol), so could you please direct me to the easiest way of making this automatically.
There is a button on the powerpoint menu (mine is in German, so not sure how exactly it is translated in English, but here it is: Diagrammtools -> Entwurf (the left one out of three) -> Daten -> Daten aktualisieren) but it is constantly in a shade, so I am not really sure how to "activate" it..
I don't mind doing macros (not sure how to code them tho; and also I'll most probably have to teach the guy who will use the PPpresentation afterwards how to use the macros :D), but would appreciate if you could direct me to the pretty much easiest way of refreshing all these diagrams without having to open their spreadsheets one by one![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Cheers in advance!
P.S. Let me know if I'll need to clarify anything on my issue here.
first off not sure if here is the place for this issue, so pls direct me if I'm on the wrong street
Straigth to the point >_> I got some 80ish slides with diagrams all of which are linked to an Excel book with several spreadsheets. When I have the master excel book and the temporal spreadsheet for the respective diagram everything is fine.
But if I change something on the spreadsheet, then all the 80 diagrams should be refreshed. I don't want to be opening them one by one (lol), so could you please direct me to the easiest way of making this automatically.
There is a button on the powerpoint menu (mine is in German, so not sure how exactly it is translated in English, but here it is: Diagrammtools -> Entwurf (the left one out of three) -> Daten -> Daten aktualisieren) but it is constantly in a shade, so I am not really sure how to "activate" it..
I don't mind doing macros (not sure how to code them tho; and also I'll most probably have to teach the guy who will use the PPpresentation afterwards how to use the macros :D), but would appreciate if you could direct me to the pretty much easiest way of refreshing all these diagrams without having to open their spreadsheets one by one
Cheers in advance!
P.S. Let me know if I'll need to clarify anything on my issue here.