Linked Picture Formatting

Question

I am having trouble with linked pictures. When I add formatting, in this case glow, it initially appears. But after a minute or so it will remove the glow and make the picture slightly larger (about the same size as the original picture + glow).

My dashboard is updated using a macro, so I tried to use VBA code to get around having to use a linked picture. But I code at a 1st grade level so I did not have any luck, even after consulting google. Any suggestions?

Answer 1

Hi,

Welcome to the community forum.

Based on your descriptions, you are trying to use VBA to adding dynamic linked picture to your Excel dashboard because you meet a format issue with your linked picture.

If my understanding is correct, please kindly check this reference VBA code template: Using the Camera in VBA (Microsoft Excel) (tips.net)

It can specify a range to be copied, it then copies it to the Clipboard as a picture, and prompts you for where to paste it. 

* Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

By the way, for the format linked picture issue, I cannot reproduce by my side. And this is not an expected behavior. You can try Repair an Office application (microsoft.com) to see whether it can help you fix the issue at the same time.

Hope all the information above can help you a little. If I have any misunderstanding or if the information doesn’t quite work for you, please reply back for free.

Best Regards,

Rena