Paste Special doesn't work

%3CLINGO-SUB%20id%3D%22lingo-sub-2305876%22%20slang%3D%22en-US%22%3EPaste%20Special%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2305876%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%20I%20have%20a%20question%20about%20Excel.%20I%20would%20like%20to%20copy%20a%20graph%20from%20one%20Excel%20file%20to%20another%20Excel%20file%2C%20but%20in%20such%20a%20way%20that%20both%20graphs%20update%20automatically.%20I%20have%20already%20seen%20on%20the%20internet%20that%20this%20should%20be%20possible%20via%20special%20paste%2C%20but%20somehow%20I%20cannot%20choose%20that%20option%20when%20I%20want%20to%20paste%20the%20graph.%20I%20can%20press%20paste%20special%2C%20but%20then%20I%20can%20only%20choose%20'Paste'%20and%20not%20'Paste%20link'.%20Paste%20special%20does%20work%20by%20the%20way%20when%20I%20paste%20the%20graph%20into%20powerpoint%20or%20word.%20I%20am%20using%20Microsoft%20Excel%202013.%20Greetings%2C%20Sandra%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2305876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2306092%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20Special%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1040502%22%20target%3D%22_blank%22%3E%40Sandr330%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20might%20use%20the%20Camera%20tool%20for%20this%20-%20see%20%3CA%20href%3D%22https%3A%2F%2Fwww.officetooltips.com%2Fexcel_2016%2Ftips%2Fhow_to_use_camera_tool_in_excel.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHow%20to%20use%20Camera%20tool%20in%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good morning, I have a question about Excel. I would like to copy a graph from one Excel file to another Excel file, but in such a way that both graphs update automatically. I have already seen on the internet that this should be possible via special paste, but somehow I cannot choose that option when I want to paste the graph. I can press paste special, but then I can only choose 'Paste' and not 'Paste link'. Paste special does work by the way when I paste the graph into powerpoint or word. I am using Microsoft Excel 2013. Greetings, Sandra

 

1 Reply

@Sandr330 

You might use the Camera tool for this - see How to use Camera tool in Excel