View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excelerate-nl Excelerate-nl is offline
external usenet poster
 
Posts: 33
Default How to copy worksheet layout, values and graph as picture

Dear Excel expert,

I'm trying to copy some worksheets to a new workbook. The sheets contain
formulas and graphs with references to other sheets. Therefor I would like to
have these references removed, thus copy them as values (but I also need the
same format/layout). The graphs should be copied as pictures to remove the
references.
I have succeeded in removing formula references by the copy - paste as
values methode, but I hope there is another methode. Converting a copied
graph into a picture within Excel doesn't work (only in Word I'm able to
paste it as a picture)

Regards,

jan Bart