Why does paste as link not copy across all the conditional formatting for cells from Excel?

Carkcark

New Member
Joined
Dec 13, 2016
Messages
8
I have a table (though not actually formatted as a table) in Excel which has a lot of percentage values with conditional formatting which changes the cell colour based on the calculated formula's value.

When I copy the Excel table into Powerpoint using the Paste As Link, only the majority of the top left corner of the table pulls through the conditional formatting colours and the rest just appears white / no fill. Everything shows correctly in the Excel spreadsheet, but just doesn't pull through in Powerpoint.

Am I just trying to copy too many cells? The region I am trying to copy is 30 columns wide by 30 rows.

Anyone know the reason?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,122,529
Messages
5,596,695
Members
414,088
Latest member
rodriboraun

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