I am trying to think of the best way to automate between Excel and PowerPoint. I have an Excel sheet with multiple tabs and over 40 graphs that I copy/paste into a PPT.
I would link the graphs, however, in the final version of the PowerPoint i cannot have the recipient see the underlying data. Also, when pasting the graph it does not look as good as the picture view since then I can resize it. This process will happen for 5 PowerPoint decks and be quarterly.