Chart is automatically pasted as a linked chart: how to disable it?

Larry Goldstein 10 Reputation points
2023-06-16T16:18:31.91+00:00

Hi,

We have noticed that copy-pasting a chart from Excel to PowerPoint now creates, by default, a linked chart (i.e. if data changes in Excel it changes in PowerPoint) instead of a non-linked chart as it was before.

  1. What Office version introduced this new behavior?
  2. How can this feature be disabled?
  3. What future developments on the Excel to PowerPoint link are planned by Microsoft?

Thank you,

Larry

PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
291 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanay Prasad 2,120 Reputation points
    2023-06-19T05:49:56.5033333+00:00

    Hi,

    To disable the creation of linked charts when copy-pasting from Excel to PowerPoint, you can adjust the paste options settings in PowerPoint. Here's how:

    • Copy the chart in Excel.
    • In PowerPoint, go to the slide where you want to paste the chart.
    • Use the keyboard shortcut Ctrl+Alt+V or right-click and choose "Paste Options" to open the paste options menu.
    • From the menu, select the desired paste option, such as "Keep Source Formatting" or "Use Destination Theme," instead of "Keep Source Formatting & Link Data."
    • Choose the paste option that suits your needs, and the chart will be pasted as a non-linked chart.

    Best Regards.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.