SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Updating data in embedded excel worksheets

Occasional Contributor
Posts: 15

Updating data in embedded excel worksheets

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.


Ask a Question
Discussion stats
  • 0 replies
  • 1 in conversation