Paste Special Linked Excel Graphs Change on their own

Copper Contributor

I am currently using Office 2013. I have set up a number of graphs in Excel (around 100 individual graphs) and these graphs have been Special Pasted by link to a number of different Publisher files. The idea is that I can update the graphs in Excel and have them auto update in Publisher when I send out these monthly reports (the Publisher files). The only problem is, over time the graphs get jumbled and will randomly link to different graphs in the source worksheet. I don't know why or how. I have tried everything I can think of to recreate the problem but to no avail. If I re-link the graphs they will stay good through all my tampering (i.e. moving the source graphs, creating copies, renaming the graphs, changing the data, repeated saving and updating) But next month when I go to refresh the reports the graphs will randomly link to the wrong sources. Any suggestions would be appreciated. I'm really tired of recreating these reports every month.

0 Replies