T
Tante To
I have linked a Excel sheet to a PowerPoint sheet. The Excel uses filters to limit what is shown.
So, when copying $A$1:$D60 to my slide only 5 lines are shown in the Excel. And because it is linked in PowerPoint, it also only shows 5 lines on my slide.
However, when the Excel data changes and 10 lines fit the filter set, 10 lines are shown. In PowerPoint also 10 lines are shown, but the position of the lines on the slide changes. For example, the lines move up, and cover other objects on the slide.
My question: how do I fix the position of the Excel 'import' on my PowerPoint slide? So, when the shown items increase, the position of the lines on my slide don't get all screwed up.
For example: the top line always start at X=1 and Y-1 on my slide.
So, when copying $A$1:$D60 to my slide only 5 lines are shown in the Excel. And because it is linked in PowerPoint, it also only shows 5 lines on my slide.
However, when the Excel data changes and 10 lines fit the filter set, 10 lines are shown. In PowerPoint also 10 lines are shown, but the position of the lines on the slide changes. For example, the lines move up, and cover other objects on the slide.
My question: how do I fix the position of the Excel 'import' on my PowerPoint slide? So, when the shown items increase, the position of the lines on my slide don't get all screwed up.
For example: the top line always start at X=1 and Y-1 on my slide.