Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the paste link function in Excel 2003 | Excel Worksheet Functions | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel | |||
Paste a chart as a link? | Charts and Charting in Excel |