Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2010, 10:02 AM
Tonto Tonto is offline Embedding Excel charts in PPT or Word Windows XP Embedding Excel charts in PPT or Word Office 2007
Novice
Embedding Excel charts in PPT or Word
 
Join Date: Dec 2010
Posts: 2
Tonto is on a distinguished road
Default Embedding Excel charts in PPT or Word

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
Reply With Quote
  #2  
Old 12-29-2010, 09:48 AM
KsT KsT is offline Embedding Excel charts in PPT or Word Windows XP Embedding Excel charts in PPT or Word Office 2007
Novice
 
Join Date: Nov 2010
Location: Northeast
Posts: 10
KsT is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 01-05-2011, 02:19 PM
Tonto Tonto is offline Embedding Excel charts in PPT or Word Windows XP Embedding Excel charts in PPT or Word Office 2007
Novice
Embedding Excel charts in PPT or Word
 
Join Date: Dec 2010
Posts: 2
Tonto is on a distinguished road
Default

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 .
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedding Excel Object in Word Document Failing brandonf Word 0 10-04-2010 11:45 AM
Embedding Text in MS Word ralphe Word 0 09-30-2010 01:41 PM
Where is "scale to fit" option (for charts) in Excel 2007? yinchiao Excel 0 04-08-2010 05:00 PM
Word 2007 Color Charts Print in Grayscale AgDad Word 4 10-12-2009 08:55 AM
copy/paste charts from excel to word bielak01 Excel 0 04-16-2009 02:27 AM


All times are GMT -7. The time now is 05:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft