Link from Excel worksheet to Powerpoint truncated


A

AleVe

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.
 
Ad

Advertisements

A

AleVe

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.
 
M

Michael Koerner

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

AleVe

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
 
M

Michael Koerner

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.
 
Ad

Advertisements

A

AleVe

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.
 
A

AleVe

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

AleVe

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).
 
A

AleVe

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
 
A

AleVe

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.
 
Ad

Advertisements

A

Arif Evm

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 thin
this is where the problem come from
By the way, I have also the SP2 installed on my computer

:

Previous Posts In This Thread:

Link from Excel worksheet to Powerpoint truncated
Subject : When I try to copy paste a table from excel to powerpoint, th
corresponding file path to have updated automatically is not correctly kep
in the ppt file

Details : I amusing Powerpoint 2007 and Excel 200
I have an excel file usually updated and I would like to copy paste th
charts and tables in a powerpoint file, and to have only to click on th
"Update link" button when I open my ppt file, to have all my data refreshe
with what present in the excel file
it is correctly working with a simple copy paste for the charts, but not fo
the tables
The issue is the followin

Steps
1. I copy my table from excel worksheet (select the table and do a simpl
Ctrl + C
2. I go on my ppt file and do Paste -> Paste Special -> Paste links -
Microsoft Office Excel Worksheet Objec
3. I check the path identified for this table by the ppt file, so I click o
Menu -> Prepare -> Edit Links to Files. The link here is correct (e.
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), s
the file is not able to retrieve the excel data to update my table.

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

-
Michael Koerne
MS MVP - PowerPoint

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 t
the root to have less characters in my path

Thank you it helps

:

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

-
Michael Koerne
MS MVP - PowerPoint

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 folde
to have a shorter path), but powerpoint still truncate the link of my table
at the same folder

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

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

:

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 puttin
it in the same folder as your presentation and then insert it into you
presentation and see what happens. The 128 characters also includes space
in the count

-
Michael Koerne
MS MVP - PowerPoint

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

After moving my excel file, I reopened my powerpoint and correctl
reinserted all the sharts and tables
As told, the charts are correctly refreshed when updating my excel file, bu
the tables are not (due to this path issue)

I still do not understand why the full path is not kept, since I verifie
that the total path was under a total of 128 characters

:

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

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.

:

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/

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).

:

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/

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

:

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/

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.

:


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/tutorial...dfe-9f7a28f4d58e/filebased-cache-for-web.aspx
 
Ad

Advertisements

A

Arif Evm

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/tutorial...0-a5704fe31a76/biztalk-repeating-structu.aspx
 

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