Forum Discussion

Copper Contributor

Mar 11, 2022

How to Automatically Move Image Upon Pivot Table Refresh

Hello, I have a pivot table that will grow in size with every refresh, and I need a way for the image below the pivot to automatically move down until it finds a blank space. Refreshing the pivot ta...

excel

NikolinoDE

Platinum Contributor

Mar 12, 2022

MrWeissman

maybe with VBA 🙂

Sub Resizeallimages ()
    Dim objPic As Object
    
    For Each objPic In ActiveSheet.Pictures
         'Format all graphics :
       With objPic.ShapeRange
            .LockAspectRatio = False
            'Please adjust the width and height of the graphic in brackets here:
            .Height = Application.CentimetersToPoints(6.75)
            .Width = Application.CentimetersToPoints(9.05)
        End With
    Next
End Sub

or...

Images in Power View

Images are great for adding visual appeal to a Power View sheet in Excel or to Power View in SharePoint. See in the upper link for more Informations.

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.