Linking to PowerPoint: Named Range Mystery

furiouseskimo

New Member
Joined
Apr 2, 2008
Messages
1
Hi

Thanks in advance for the help with this. It's driving me crazy.

I'm having a problem linking my named ranges in an Excel worksheet to PowerPoint.

I select the named range in Excel
Copy it
Switch to PowerPoint
Double-click into a Chart
Click Edit > Paste Link > Ok.

This is when the problem occurs, as no data appears in the datasheet of my chart.

While the chart is still open, if I choose
Edit > Links > Change Source,
I can see that the link pasted across is not !test (the name of my named range), it's !Sheet1!R1C1:R4C5Test i.e. it has pasted the absolute cell references and the name of the named range after it. This is causing the problem.

A similar problem occurs when I try to link some cells in the Excel sheet to a textbox in PowerPoint. The name of the named range does not come up; just the absolute cell reference !Sheet1!R1C1:R4C5

This is driving me up the wall and threatens to ruin a couple of days of work that I've done.

If anyone can help me with this, I'd greatly appreciate it.

Thanks
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
Hello and welcome to The Board.
Have you tried Edit | Paste Special and then selecting 'Paste Link' and also "Microsoft Office Excel Worksheet Object"?
That seems to work for me (I am using Office 2007).
 

excelaraviind

New Member
Joined
Feb 21, 2017
Messages
1
Change the name of the sheet to something that has space in between. Example : Sheet named "Carline" could be renamed as "Carline Main". After this when you paste the named range in powerpoint then the reference will be the named range instead of R1C1 formula
 

Watch MrExcel Video

Forum statistics

Threads
1,122,912
Messages
5,598,833
Members
414,260
Latest member
joishe

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