Linked Excel Table will not show inserted rows or columns

M

Martin Hanson

I took a 5c x 10 row table from an excel worksheet (2007) and pasted speacial
as a Microsoft Office Excel Worksheet Object. That went fine. The values
update when I click on the object in PowerPoint--don't see any other way to
update the values.

However, if I insert a column in Excel, say in the middle of the columns,
the inserted column is displayed correctly and the other columns are shifted
to the right, but in this case the 5th column is dropped--the object didn't
expand to include the insertion of the column, it scrolled out of the object
to the right. The same thing happens if I insert a row in the source data in
Excell--the rows scoll out of the object out the bottom.

Is this normal? Is there a way to make this a "perfect" link so that
insertions and deletions are updated automatically in PowerPoint?

Thanks in advance.
 

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