Dynamic Named range copied to Powerpoint

Hello,

I have a worksheet in excel which would have different number of rows on almost every update. How can I paste it in Powerpoint so the powerpoint would reduce and increase the number of rows until the end of the worksheet please ?

I have googled and some are recommending to use Dynamic Named Ranges called 'Actions' which I have created as " =OFFSET('Action Tracker'!$A$2, 0, 0, COUNTA('Action Tracker'!$A:$A,1))"

The number of columns in my worksheet dont change.

I then select the sheet - Ctrl A, ctrl C and Paste special - Paste link the worksheet but it doesnt copy the named range

I am sure I am doing soemthing wrong in copy and pasting but unsure what ?

First tab and slide is a range

copied as table from tab 2 on slide 2 and then deleted a few rows.

I cant be that stupid... but is there something fundamentally wrong I am doing here !!! . so going to absolute basics

on Excel - select the area and Format Table.

Select All and Copy All on Excel and Paste Special on Powerpoint.

Guess my Office is broken then !

Hi Used to the point identical method to link ActionTracker ( as a table) and Problemss ( as a named range) to link CSIP and High Priority worksheets.... but they continue to link static range ! its getting beyond annoying !

Got a colleague to try too and failed. COuld having file on the server create a problem ?

https://www.mrexcel.com/board/…med-range-mystery.383233/

Change the name of the sheet to something that has space in between. Example : Sheet named "Carline" could be renamed as "Carline Main". After this when you paste the named range in powerpoint then the reference will be the named range instead of R1C1 formula

Solved !! This makes my blood boil ! Does MS know of this ?!!