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