PDA

View Full Version : change path of Linked Excel object



mooseman
05-05-2011, 07:33 AM
I have a presentation with 100's of slides that are all exactly the same layout, charts, tables, etc.
I want to make a 2007 presentation template slide and then copy it multiple times and change the links/data on each slide.

I have a problem with changing the path of a linked Excel object. I can change the source file, but not the sheet or cell it is pointing to.

Here is what did.
1) select cell b2 on sheet 1
2) paste special as link Excel worksheet object

I now want to change this to point to sheet2 and cell b3.....
how do I do this?
Thanks