Hello
I have PowerPoint, with charts and tables from one Excel file. I would like to write macro in PowerPoint, which will update data in all charts and tables. Data in Excel is changed when PowerPoint is closed and PowerPoint is using when Excel is closed. As far I have written macro, which opens Excel file, but then data isn't actualized automatically. I need to click update link or change data in each object manually.
I have PowerPoint, with charts and tables from one Excel file. I would like to write macro in PowerPoint, which will update data in all charts and tables. Data in Excel is changed when PowerPoint is closed and PowerPoint is using when Excel is closed. As far I have written macro, which opens Excel file, but then data isn't actualized automatically. I need to click update link or change data in each object manually.