Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2012, 08:58 AM
Erdvige Erdvige is offline Turning off automatic links to Excel charts Windows 7 64bit Turning off automatic links to Excel charts Office 2010 64bit
Novice
Turning off automatic links to Excel charts
 
Join Date: Apr 2012
Posts: 3
Erdvige is on a distinguished road
Default Turning off automatic links to Excel charts

Alright, I just got upgraded to Office 2010. I don't know if there is an option for this (god knows I've tried looking). I have a powerpoint I am copying a large number of charts into. Problem is, I am copying them from an Excel tool created by IT in which I simply select the agency and it auto-generates the numbers into a bar chart and pie chart, so I am essentially copying from the same chart over and over.



Powerpoint seems to think I want the information linked every time I just copy it over. I don't want it linked. Yes, I know I can manually change it each and every time, but every so often I forget, change the information in the chart, and have to go back and regenerate the previous chart to fix the mistake. Is there any option in Powerpoint to just stop this? I'd like to be able to just copy-past repeatedly and not have to worry about whether I remembered to copy without links. This task is tedious enough as it is without this frustration.
Reply With Quote
  #2  
Old 04-26-2012, 09:05 AM
JohnWilson JohnWilson is offline Turning off automatic links to Excel charts Windows 7 64bit Turning off automatic links to Excel charts Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

To be clear, are you copying / pasting manually or does the IT tool do it for you?
Once in PPT do you need to edit the chart data?
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 04-26-2012, 09:06 AM
Erdvige Erdvige is offline Turning off automatic links to Excel charts Windows 7 64bit Turning off automatic links to Excel charts Office 2010 64bit
Novice
Turning off automatic links to Excel charts
 
Join Date: Apr 2012
Posts: 3
Erdvige is on a distinguished road
Default

I am copying manually. Since I have issues with carpal tunnel in my right hand, I depend on a lot of alt-tabbing and shortcut keys rather than using the mouse, so it would be very easy for me if I can just ctrl-c/ctrl-v my way through this quickly.

Edit: I realize I did not answer the other part of your question. I do not have to change the information, just copy the chart over. The slides are already formatted the way I want them, so the chart pops right into place.
Reply With Quote
  #4  
Old 04-26-2012, 09:25 AM
JohnWilson JohnWilson is offline Turning off automatic links to Excel charts Windows 7 64bit Turning off automatic links to Excel charts Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

There's no way to alter the default paste. You can RIGHT click and get options instead.

Beware though the default was changed for a very good reason. It was possible to recover ALL data (not just the chart data) from the non linked excel. This could be embarressing ask Sarah Palin!

You might want to try pasting as an image. It is possible to do this from the keyboard

CTRL ALT V
Release these!
Down arrow
ENTER
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #5  
Old 04-26-2012, 09:30 AM
Erdvige Erdvige is offline Turning off automatic links to Excel charts Windows 7 64bit Turning off automatic links to Excel charts Office 2010 64bit
Novice
Turning off automatic links to Excel charts
 
Join Date: Apr 2012
Posts: 3
Erdvige is on a distinguished road
Default

Alright, I suppose that is what I will have to do. Thank you for your assistance!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Puzzled--Excel charts in PPT change color when PDF'd Spocky Excel 0 04-28-2011 07:13 AM
PPT 2010 - Removing links from charts Warren PowerPoint 0 02-10-2011 01:56 AM
Embedding Excel charts in PPT or Word Tonto Excel 2 01-05-2011 02:19 PM
Turning off automatic links to Excel charts Automatic Update of links has been disabled: Kal Excel 1 03-21-2010 09:37 AM
copy/paste charts from excel to word bielak01 Excel 0 04-16-2009 02:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 PM.


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