Automatic updating of excel tables in powerpoint slides
For our e-learning modules, we use Power Point 2007 with Articulate Studio ’09.
I created a 35 minute long web-based training (WBT) that is all about the forecasted energy usage for the upcoming summer.
Tables and charts within Power Point operate very differently, and this influences their respective ability to be automatically updated.Power Point saves the template as an external file. Certain (clever) programs can reference this file when they instruct Power Point to build a chart. Check out Q’s wiki for some general tips that apply regardless of whether you are using Q or not.The that external software can reference as it speaks to Power Point.This lack of a hidden data spreadsheet with tables, has implications on the design of tables as well.Because external software will paste information into the table (as text, including the labels), any modifications that you had manually made to the format of the text/numbers previously may get overridden in the updating process.