Link from Excel worksheet to Powerpoint truncated

AleVe

unread,

Feb 23, 2010, 5:24:01 AM2/23/10

to

Subject : When I try to copy paste a table from excel to powerpoint, the
corresponding file path to have updated automatically is not correctly kept
in the ppt file.

Details : I'musing Powerpoint 2007 and Excel 2007
I have an excel file usually updated and I would like to copy paste the
charts and tables in a powerpoint file, and to have only to click on the
"Update link" button when I open my ppt file, to have all my data refreshed
with what present in the excel file.
It's correctly working with a simple copy paste for the charts, but not for
the tables.
The issue is the following

Steps:
1. I copy my table from excel worksheet (select the table and do a simple
Ctrl + C)
2. I go on my ppt file and do Paste -> Paste Special -> Paste links ->
Microsoft Office Excel Worksheet Object
3. I check the path identified for this table by the ppt file, so I click on
Menu -> Prepare -> Edit Links to Files. The link here is correct (e.g
D:\Documents and Settings\...\last folder\file.xlsx)
4. I save my ppt file and then close ppt.
5. I open again my ppt file and go to check the path for the table pasted.
The path has been truncated and it only remains last folder\file.xlsx), so
the file is not able to retrieve the excel data to update my table.

Michael Koerner

unread,

Feb 23, 2010, 8:11:05 AM2/23/10

to

Is the link longer than 128 characters? That would cause it to truncate.

--
Michael Koerner
MS MVP - PowerPoint

"AleVe" <Al...@discussions.microsoft.com> wrote in message
news:893EA125-408A-4E2E...@microsoft.com...

AleVe

unread,

Feb 23, 2010, 8:21:01 AM2/23/10

to

Sure, my link is about 155 characters, I will save my excel file closer to
the root to have less characters in my path.

Thank you it helps.

Michael Koerner

unread,

Feb 24, 2010, 10:45:35 AM2/24/10

to

Glad to hear that it worked. Me, I'm from the old school and still maintain
the 8.3 mentality

--
Michael Koerner
MS MVP - PowerPoint

"AleVe" <alex...@hotmail.com> wrote in message
news:1B78A041-6B94-417A...@microsoft.com...

AleVe

unread,

Feb 26, 2010, 5:20:01 AM2/26/10

to

Hi,

Unfortunately, I now checked that this is still not working.
Now my links have less than 128 characters (I move my file to another folder
to have a shorter path), but powerpoint still truncate the link of my tables
at the same folder.

EX : my file was before located at D:\Documents and Settings\folder 1\folder
A\file.xlsx
truncated at folder A\files.xlsx

I moved it to D:\folder A\file.xlsx
truncated at folder A\files.xlsx

Michael Koerner

unread,

Feb 26, 2010, 6:26:26 AM2/26/10

to

Once you moved it, did you reinsert it again with the new path? Try putting
it in the same folder as your presentation and then insert it into your
presentation and see what happens. The 128 characters also includes spaces
in the count.

--
Michael Koerner
MS MVP - PowerPoint

"AleVe" <alex...@hotmail.com> wrote in message

news:A3D353C3-4CB0-4141...@microsoft.com...

AleVe

unread,

Feb 26, 2010, 10:23:02 AM2/26/10

to

Hi,

After moving my excel file, I reopened my powerpoint and correctly
reinserted all the sharts and tables.
As told, the charts are correctly refreshed when updating my excel file, but
the tables aren't (due to this path issue).

I still don't understand why the full path is not kept, since I verified
that the total path was under a total of 128 characters.

Steve Rindsberg

unread,

Feb 26, 2010, 11:29:40 AM2/26/10

to

I'm not sure if this will have an effect, but check the presentation properties;
Make sure Hyperlink Base is blank.

Pack a lunch; this is a far longer trip than it ever deserved to be:

Office Button | Prepare | Properties
Basic doc properties appear above the slide
Click the downarrow next to "Document Properties"
Choose Advanced Properties
Click the Summary tab in the Presentation Properties dialog bx that appears
Hyperlink Base is the last textbox at the bottom.

==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

AleVe

unread,

Feb 26, 2010, 12:21:01 PM2/26/10

to

Thanks for your answer, but I just checked and the Hyperlink Base was well
left blank.

Steve Rindsberg

unread,

Feb 26, 2010, 3:56:21 PM2/26/10

to

OK, at least we know we can eliminate that.

Are you running any add-ins that might deal with links and such?

AleVe

unread,

Mar 1, 2010, 4:28:01 AM3/1/10

to

Hi Steve,

Not any add-ins could deal with the issue.
One strange thing is that, when I refer to the office support, to check how
to copy paste excel tables, in order to keep the link between excel and ppt,
they explain that a simple Crtl C, Ctrl V works, and checking the paste
options. The fact is that when I copy paste my table I don't even see these
paste options (they're correctly acrivated in the powerpoint general options
and work fine with the charts once more).

Steve Rindsberg

unread,

Mar 1, 2010, 3:15:50 PM3/1/10

to

In article <89CC19A3-B0E0-4755...@microsoft.com>, AleVe wrote:
> Hi Steve,
>
> Not any add-ins could deal with the issue.
> One strange thing is that, when I refer to the office support, to check how
> to copy paste excel tables, in order to keep the link between excel and ppt,
> they explain that a simple Crtl C, Ctrl V works, and checking the paste
> options.

Sometimes it works for some people, apparently. It never has for me. Instead,
select the information you want to copy in Excel then use the Copy command from
the ribbon bar rather than keyboard shortcuts.

Then in PPT, use the down arrow beneath Paste, choose Paste Special then pick MS
Excel Worksheet object (or similar wording) and put a check next to Link.

See if that helps.

>
> "Steve Rindsberg" wrote:
>
> > OK, at least we know we can eliminate that.
> >
> > Are you running any add-ins that might deal with links and such?
> >
> >
> > In article <81F9B7AC-C980-4F65...@microsoft.com>, AleVe wrote:
> > > Thanks for your answer, but I just checked and the Hyperlink Base was well
> > > left blank.
> > >

AleVe

unread,

Mar 2, 2010, 10:50:02 AM3/2/10

to

Hi Steve,

I tried by copying the table with the ribbon, but it doesn't work. And the
way to paste you described was exactly the one I'm used to use.

The fact is that just after copying my table as a MS excel object, checking
link, I'm able to see the right path under Prepare and Edit links. But as
soon as I saved my ppt and closed it, once I re open it, the links are
truncated.

I guess I will have to whether keep on copy pasting manually all my tables
or check if the issue also exist on Excel 2010.

However, many thanks for your suggestions and help.

Alex

"Steve Rindsberg" wrote:

> .
>

Steve Rindsberg

unread,

Mar 2, 2010, 11:39:40 AM3/2/10

to

Ah, wait a second. Is your Excel file on a network drive?
There were some problems like this with links to files on network shares.
I think SP2 fixed that, so if the shoe fits:

- Move the files to a local drive and see if it works there
- If you haven't installed SP2, consider installing it.

AleVe

unread,

Mar 3, 2010, 7:23:01 AM3/3/10

to

Unfortunately, I was already working only from my local HDD, so I don't think
this is where the problem come from.
By the way, I have also the SP2 installed on my computer.

"Steve Rindsberg" wrote:

> .
>

arifevm

unread,

Mar 25, 2010, 5:40:29 AM3/25/10

to

Hi Alex

I am also facing the same problem in powerpoint. did you solve this issue ?. if it is solved please describe how it is .

regards

arif

AleVe wrote:

Unfortunately, I was already working only from my local HDD, so I do not
03-Mar-10

Unfortunately, I was already working only from my local HDD, so I do not think

this is where the problem come from.
By the way, I have also the SP2 installed on my computer.

"Steve Rindsberg" wrote:

Previous Posts In This Thread:

On Tuesday, February 23, 2010 5:24 AM
AleVe wrote:

Link from Excel worksheet to Powerpoint truncated

Subject : When I try to copy paste a table from excel to powerpoint, the
corresponding file path to have updated automatically is not correctly kept
in the ppt file.

Details : I amusing Powerpoint 2007 and Excel 2007

I have an excel file usually updated and I would like to copy paste the
charts and tables in a powerpoint file, and to have only to click on the
"Update link" button when I open my ppt file, to have all my data refreshed
with what present in the excel file.

it is correctly working with a simple copy paste for the charts, but not for

the tables.
The issue is the following

Steps:
1. I copy my table from excel worksheet (select the table and do a simple
Ctrl + C)
2. I go on my ppt file and do Paste -> Paste Special -> Paste links ->
Microsoft Office Excel Worksheet Object
3. I check the path identified for this table by the ppt file, so I click on
Menu -> Prepare -> Edit Links to Files. The link here is correct (e.g
D:\Documents and Settings\...\last folder\file.xlsx)
4. I save my ppt file and then close ppt.
5. I open again my ppt file and go to check the path for the table pasted.
The path has been truncated and it only remains last folder\file.xlsx), so
the file is not able to retrieve the excel data to update my table.

On Tuesday, February 23, 2010 8:11 AM
Michael Koerner wrote:

Is the link longer than 128 characters?
Is the link longer than 128 characters? That would cause it to truncate.

--
Michael Koerner
MS MVP - PowerPoint

On Tuesday, February 23, 2010 8:21 AM
AleVe wrote:

Sure, my link is about 155 characters, I will save my excel file closer tothe
Sure, my link is about 155 characters, I will save my excel file closer to
the root to have less characters in my path.

Thank you it helps.

"Michael Koerner" wrote:

On Wednesday, February 24, 2010 10:45 AM
Michael Koerner wrote:

Glad to hear that it worked.

Glad to hear that it worked. Me, I am from the old school and still maintain
the 8.3 mentality

--
Michael Koerner
MS MVP - PowerPoint

On Friday, February 26, 2010 5:20 AM
AleVe wrote:

Hi,Unfortunately, I now checked that this is still not working.
Hi,

Unfortunately, I now checked that this is still not working.
Now my links have less than 128 characters (I move my file to another folder
to have a shorter path), but powerpoint still truncate the link of my tables
at the same folder.

EX : my file was before located at D:\Documents and Settings\folder 1\folder
A\file.xlsx
truncated at folder A\files.xlsx

I moved it to D:\folder A\file.xlsx
truncated at folder A\files.xlsx

"Michael Koerner" wrote:

On Friday, February 26, 2010 6:26 AM
Michael Koerner wrote:

Once you moved it, did you reinsert it again with the new path?
Once you moved it, did you reinsert it again with the new path? Try putting
it in the same folder as your presentation and then insert it into your
presentation and see what happens. The 128 characters also includes spaces
in the count.

--

Michael Koerner
MS MVP - PowerPoint

On Friday, February 26, 2010 10:23 AM
AleVe wrote:

Hi,After moving my excel file, I reopened my powerpoint and
Hi,

After moving my excel file, I reopened my powerpoint and correctly
reinserted all the sharts and tables.
As told, the charts are correctly refreshed when updating my excel file, but

the tables are not (due to this path issue).

I still do not understand why the full path is not kept, since I verified

that the total path was under a total of 128 characters.

"Michael Koerner" wrote:

On Friday, February 26, 2010 11:29 AM
Steve Rindsberg wrote:

I am not sure if this will have an effect, but check the presentation
I am not sure if this will have an effect, but check the presentation properties;

Make sure Hyperlink Base is blank.

Pack a lunch; this is a far longer trip than it ever deserved to be:

Office Button | Prepare | Properties
Basic doc properties appear above the slide
Click the downarrow next to "Document Properties"
Choose Advanced Properties
Click the Summary tab in the Presentation Properties dialog bx that appears
Hyperlink Base is the last textbox at the bottom.

==============================
PPT Frequently Asked Questions

On Friday, February 26, 2010 12:21 PM
AleVe wrote:

Thanks for your answer, but I just checked and the Hyperlink Base was wellleft
Thanks for your answer, but I just checked and the Hyperlink Base was well
left blank.

"Steve Rindsberg" wrote:

On Friday, February 26, 2010 3:56 PM
Steve Rindsberg wrote:

OK, at least we know we can eliminate that.
OK, at least we know we can eliminate that.

Are you running any add-ins that might deal with links and such?

==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

On Monday, March 01, 2010 4:28 AM
AleVe wrote:

Hi Steve,Not any add-ins could deal with the issue.
Hi Steve,

Not any add-ins could deal with the issue.
One strange thing is that, when I refer to the office support, to check how
to copy paste excel tables, in order to keep the link between excel and ppt,
they explain that a simple Crtl C, Ctrl V works, and checking the paste

options. The fact is that when I copy paste my table I do not even see these
paste options (they are correctly acrivated in the powerpoint general options

and work fine with the charts once more).

"Steve Rindsberg" wrote:

On Monday, March 01, 2010 3:15 PM
Steve Rindsberg wrote:

Sometimes it works for some people, apparently. It never has for me.
Sometimes it works for some people, apparently. It never has for me. Instead,
select the information you want to copy in Excel then use the Copy command from
the ribbon bar rather than keyboard shortcuts.

Then in PPT, use the down arrow beneath Paste, choose Paste Special then pick MS
Excel Worksheet object (or similar wording) and put a check next to Link.

See if that helps.

==============================

PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

On Tuesday, March 02, 2010 10:50 AM
AleVe wrote:

Hi Steve,I tried by copying the table with the ribbon, but it does not work.
Hi Steve,

I tried by copying the table with the ribbon, but it does not work. And the
way to paste you described was exactly the one I am used to use.

The fact is that just after copying my table as a MS excel object, checking

link, I am able to see the right path under Prepare and Edit links. But as

soon as I saved my ppt and closed it, once I re open it, the links are
truncated.

I guess I will have to whether keep on copy pasting manually all my tables
or check if the issue also exist on Excel 2010.

However, many thanks for your suggestions and help.

Alex

"Steve Rindsberg" wrote:

On Tuesday, March 02, 2010 11:39 AM
Steve Rindsberg wrote:

Ah, wait a second. Is your Excel file on a network drive?
Ah, wait a second. Is your Excel file on a network drive?
There were some problems like this with links to files on network shares.
I think SP2 fixed that, so if the shoe fits:

- Move the files to a local drive and see if it works there

- If you have not installed SP2, consider installing it.

==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

On Wednesday, March 03, 2010 7:23 AM
AleVe wrote:

Unfortunately, I was already working only from my local HDD, so I do not
Unfortunately, I was already working only from my local HDD, so I do not think

this is where the problem come from.
By the way, I have also the SP2 installed on my computer.

"Steve Rindsberg" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorials/aspnet/56161e9e-7fa3-48e8-9dfe-9f7a28f4d58e/filebased-cache-for-web.aspx

arifevm

unread,

Mar 25, 2010, 7:24:09 AM3/25/10

to

ok. i solved. it is a simple process. after linking the new object just open the link and select your newly added link and change source. then save. then open and see still the path is truncated or the whole folder is shown.
regards
arif

Arif Evm wrote:

truncating
25-Mar-10

Hi Alex

I am also facing the same problem in powerpoint. did you solve this issue ?. if it is solved please describe how it is .

regards

arif

Previous Posts In This Thread:

Submitted via EggHeadCafe - Software Developer Portal of Choice

BizTalk Repeating Structures Table Looping and Table Extract
http://www.eggheadcafe.com/tutorials/aspnet/73bf7539-4c13-43a5-a580-a5704fe31a76/biztalk-repeating-structu.aspx