I have a PPT that has many embedded charts from an Excel file. I have only seen examples of how to copy the embedded file to a drive. What I want to to do is access the Excel file, access a certain worksheet in the file and make changes to cell values to have the displayed chart in the PPT change accordingly. Can this be done? I hope I don't have to use Slides to copy the file to a drive, access and change the values with Cells and then re-embed it back to the PPT with Slides again.
Has anyone done something similar?