Controlling Excel range imported into Powerpoint

M

Matthew Schwarz

I've played around with importing Excel data into Powerpoint.

My question: is there somewhere you can explicitly specify what cell range
you want in Powerpoint?

If I bring the Excel worksheet into Powerpoint using the Insert/Object/From
File/Linked method then it seems like the range is kind of random.

If I bring the Excel data into Powerpoint by copying from Excel and then
Paste Special/Paste Link method then I get the range that I originally
copied. This is closer to what I want, but I feel a little uncomfortable
because what happens if I add columns/remove columns/add rows/remove
rows...how will the linking react to it?

What about naming a range...does that make any difference?

I guess I was looking for was a way to somehow right-click on the table from
within Powerpoint and be able to choose exactly what cell range I want
visible.

Any thoughts?
 
M

Matthew Schwarz

Steve,
Thanks for the reply.

So, just to see if I got this right:

If I copy the range A1:F10 and paste into Powerpoint, the linked area will
always be A1:F10, even though there is no "properties" section in Powerpoint
for me to see this. So if I delete column E, and column F becomes E, and then
the new column F might be blank, the portion in Powerpoint is still going to
be A1:F10?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top