View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
i compute[_2_] i compute[_2_] is offline
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