LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default prevent chart values from changing

Is there a way to do the equivalent of "PasteSpecial Paste:= xlPasteValues"
for Charts. I want to copy a sheet of embedded charts to another workbook ...
and have them look exactly the same as when I opened them. (Open with no
updating of links). But when I copy and paste the entire sheet, the charts
update.

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Values in Chart Series Karen Charts and Charting in Excel 2 July 10th 09 09:32 AM
Prevent user changing pivot chart layout Jessica Excel Worksheet Functions 0 April 15th 06 12:24 AM
Changing XValues and Values in a chart lee.christopher Excel Programming 1 August 30th 05 12:26 AM
How can I prevent a Chart from showing zero values? Quinn Ramsey Charts and Charting in Excel 4 July 27th 05 02:39 PM
how do you prevent data from changing values when sorting linked . Cassie Excel Discussion (Misc queries) 0 March 4th 05 10:45 AM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"