Linking tables in Power Point - how to handle tables that grow or shrink in size (rows only)

skyrat

New Member
Joined
Jan 20, 2015
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
I am pasting tables from Excel as a link into Power Point which works fine, until I add or delete rows to a table.

Is there a way to resolve this ?

I tried using 'Insert Table' hoping that the link would reference the table itself, rather than a cell range. But this did not work.

To clarify the issue, below are 4 tables in Excel...

1636811107041.png


Each table has to be pasted as a separate link in Power Point, because its position on the page could be anywhere...

1636811154153.png



Now if I add rows to some tables and delete rows from other tables in Excel...

1636811252810.png



The linked tables in Power Point are all wrong, so I have to delete them and paste as a link again...

1636811278819.png



If there were only one or a few tables I could copy and paste as a new link again, but the problem is I have LOTS of tables so doing this is a tedious, manual task.

And the tables are regularly being modified (only in terms of rows) so it's now becoming an issue.

I have many sheets with various numbers of tables, all of different sizes (in terms of rows).

The Power Point link is obviously just referencing the cells as a range e.g. B2:I27...

1636811818949.png


I need this link to be dynamic, so that if I add or remove rows to the table referenced as B2:I27, then it automatically updates that change to the pasted link in Power Point.

This is why I was hoping 'Insert Table' would work so it references it as 'Table12' for example, rather than B2:I27.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

severynm

Active Member
Joined
Jan 8, 2021
Messages
340
Office Version
  1. 365
Platform
  1. Windows
I am not 100% sure of this, but I noticed that your tables are all on top of each other in the same columns. I don't entirely know how the linking works exactly, but I wonder if it is based off a cell reference in the sheet, and changing the relative location of the table within the worksheet (i.e. the call location of the upper left corner of the table) is "breaking" things.

What if you had the tables side by side instead? Or even better, in different worksheets?
 
Upvote 0

skyrat

New Member
Joined
Jan 20, 2015
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
What if you had the tables side by side instead? Or even better, in different worksheets?

This is the only way I could think of resolving it but it would not be feasible.

There are hundreds of tables, so having each table side by side or on different sheets would make it very difficult to manage in excel
 
Upvote 0

skyrat

New Member
Joined
Jan 20, 2015
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
I found the solution so thought I would share

I selected the table in Excel and then selected 'Define Name', in the screenshot below I called it 'MyTable1'

With 'MyTable1' selected, I copied and pasted as a link in powerpoint.

I did the same with every table and now if I add or delete rows from a table, it does not mess the other tables up in the power point and the table I modify grows or shrinks in the power point.

I also noticed something else....

When I pasted the links without naming the tables, powerpoint shows that each link has an absolute path so if the Excel file is not in that path it cant find the link, even if the Excel file is placed in the same folder as the Powerpoint file. This is a problem people have asked about online but with no solution other than manually changing the link or using a VBA script.

However, when I pasted the links after naming the tables, if the Excel file is in the same folder as the Powerpoint it finds the link even though the absolute path does not even exist.

So naming tables and pasting as a link has fixed the absolute path problem too !



1638351436082.png
 
Upvote 0
Solution

Forum statistics

Threads
1,186,997
Messages
5,961,012
Members
438,514
Latest member
AngSP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top