Linked Excel chart in PPT (update issues)

0
votes

i have some Data output (output.xlsx with multiple sheets). i need these informations in Powerpoint-slides as a chart. so i create the chart in Powerpoint(insert chart -> edit Data in excel (new excel window opened) -> create a link to the output.xlsx (=[output.xlsx]Sheet1'A1 )

next month i get a new output.xlsx (same format but new values). i save the new output.xlsx in the same folder like the last one (overwrite). then i open the powerpoint slides but i get no question to update the links.

on the "File" tab in powerpoint there is no information of the linked excel sheet. to update the values i need to click into the chart -> edit data -> (excel window opens) ->data -> edit links -> update values

so the chart remembers the link only in the excel version of powerpoint but not in Powerpoint itself. i have 25 charts in this slides so it would be great if anyone knows how to update all charts at once.

any ideas :)?

best regards

1
excelpowerpoint
Does the data change when you select the chart and press Refresh Data in the Design Tab? - Stachu
i cannot click on Refresh Data (its grey), i can only click on "edit data" and "select data". - 7660

1 Answers

0
votes

Right now you do the following:

  1. create chart in PowerPoint, which creates Excel embedded in your presentation
  2. you link that Excel to the Excel with the data

I suggest skipping the intermediary and link the data directly to your Excel

  1. Create chart in your Excel with data
  2. Cut it and Paste in PowerPoint

Now when you edit the data you open the original file, and can use the Refresh button in the Design tab

EDIT the point about editing the data was just to visualize that the data is linked to the source directly. After the chart is in PowerPoint it doesn't have to be created anymore, just refreshed. It's a one time setup