Q: Name not used when paste link to PPT
 

I have a small pb. I try to create tables in PPT which are linked to
Excel. To avoid any problem with insertion of rows and columns, I use
names in the spreadsheet. Problem, it looks like Excel does not use the
name of the range systematically and use a R128C3:R162C41 reference
most of the time.

That's an issue for me. Is there a way to deal with that? I am thinking
to a specific combinaison of key to "force" excel to use array names,
or maybe a property in PPT which allows to change the R128C3:R162C41 of
the link to the array name, or perhaps the only solution is to do it in
VBA?

Thanks in advance
Charles

Q: Name not used when paste link to PPT - FOUND IT
 

Sorry, found a solution in an earlier post:

http://groups.google.co.uk/group/mic...a082566c65fda1

althought if someone has an Excel solution I am interested

Charles


Charles wrote:
I have a small pb. I try to create tables in PPT which are linked to
Excel. To avoid any problem with insertion of rows and columns, I use
names in the spreadsheet. Problem, it looks like Excel does not use the
name of the range systematically and use a R128C3:R162C41 reference
most of the time.

That's an issue for me. Is there a way to deal with that? I am thinking
to a specific combinaison of key to "force" excel to use array names,
or maybe a property in PPT which allows to change the R128C3:R162C41 of
the link to the array name, or perhaps the only solution is to do it in
VBA?

Thanks in advance
Charles