03-27-2014 03:11 PM
Has anyone had any luck automating the update of graphs within PowerPoint 2010 using the embedded Excel worksheets? I have build a PowerPoint presentation that contains about 40 graphs. Each graph is sourced from SAS data from within the embedded worksheet. The only way I have found to update the graph is by opening the embedded worksheet and then clicking the refresh button on the SAS add-in tab. There has got to be a better work around until SAS allows auto update on native PowerPoint graphs.
We are running Base SAS 9.3, Enterprise Guide 6.1, MS Office Add-In 6.1, and MS Office 2010.