I frequently embed Excel charts into Powerpoint presentations and use an add-in to periodically update the Excel data from a location on my network. Every time I close and reopen the chart from within the presentation, my addins don't show up anymore (even though they are checked as available) and I have to turn them off and then back on again for them to work.

I have even tested this with the analysis Toolpak and the same behavior occurs. The same thing happens in Word as well. Is this a limitation of the shared charting feature?



Any help anyone can provide would be appreciated

Hi Tonto,

I am not an expert on add-ins, with this in mind...What if you set up a macro in a personal workbook that you use to open or unhide the add-ins with just a ctrl+'fill in the blank' all would be available.
I use a personal workbook to store my frequently used macros and leave the personal workbook unhidden. This makes it available with any workbook I might be working on.
This a stab in the dark for me, but you did close with 'Any help anyone can provide would be appreciated' so I figured it is worth mentioning.
Please let me know either way, I don't want to lead anyone down the wrong path.

Regards,

KsT

Thanks for the suggestion KsT. I was able to create a macro to disable/enable a macro to do what I was looking for, but none of my macros are available when I open a chart through Powerpoint. So, it seems like some functions just aren't available when you open Excel data through Powerpoint .