Excel linked pictures change scale after copying sheet

I have created a dashboard sheet by using the camera tool to paste graphs from other sheets as linked picture in the dashboard sheet. When I copy the whole sheet (by right clicking the sheet tab) and paste it as a new sheet in the same workbook, the scale of my graphs reverts to the scale of the original graph. This results in the whole dashboard being distorted with overlapping graphs.

What did I do already:

googled it
I have tried numerous combinations of "Lock aspect ratio" and "Relative to original picture size" under Size, and "Move but don't size with cells", "Don't move or size with cells" under Properties.
It looks like copying every object one by one works, but if you copy the whole sheet it distorts everything.

Another guy posted exactly the same problem here but he didn't get any answer.

It would be great if someone is able to help me with this annoying problem.

Johan

Solution

I found a way around

Create a chart object (delete all chart related graphics = empty area).
Set width, height of chart object equal to your linked picture.
Click your linked picture to select and copy (Ctrl+C) then unselect.
Click chart object to select and paste (Ctrl+P)
DONE!

Now, your linked picture size won't change anymore