FYI: Link Problems in Office Products (Paste Special, Etc.)

M

Mickey

FYI. Correspondence with Microsoft Support.


Problem Description:



I have created a book I intend to publish using Word, PowerPoint, and Excel.
I am embedding hundreds of different PowerPoint slides and Excel
tables/charts into the book using the Word/Edit... Paste Special... command.
This is a multi-document book, which is going through revisions all the
time. As each chapter/document is revised (0.2 to version 0.3, etc.), it is
copied into a new folder so that the revisions can be managed properly. The
same is true of PowerPoint and Excel documents. However, this is a real
nightmare from a link perspective. The links keep getting broken and there
seems to be a very limited means to update links.



In fact, the Word/Edit.../Links... support is almost non-existent and the
links edit window is so squeezed, you cannot see the links clearly or
properly. In fact, you cannot seem to resize the window or change column
widths in the window to make the task any easier.



How can I overcome these major limitations in Word and the linkage feature??
I am desperate because I spend countless hours ungrouping captions,
re-pasting new copies of the objects, and then reformatting everything just
to get things back to where they were. Are there ways around these
limitations?



In addition, when I link tables from Excel into Word, Word will not show
Special characters properly. For instance, Symbols (e.g. code 2190 (left
arrow)) show properly in Excel but show up as big question marks in the
Edit/Paste Special... object that appears in Word. No matter what I try to
do, I cannot get these symbols to appear properly in Word. How do I
overcome this limitation in Word/Excel linkage? Does Word not recognize
Unicode? I cannot see any way around this and the symbols in
Word/Insert.../Symbols... appear to be the same as in Excel.





Please help me out of this long-term mess.





Thanks

Problem Area: Other

Frequency of problem: Always Happens

Operating system / version: Microsoft Windows XP Professional - 5.1.2600

Computer manufacturer and model: Dell Computer Corporation, Inspiron 7500

Processor model and speed: I586II, 751 MHz

Memory (RAM): 392.688 MB



------------------------------------------------------



Hi Mickey,



Thank you for using Microsoft Online Support. My name is Genevieve and I
will be working with you to resolve this issue.



In your message you've indicated that you are having problems with linked
files in a word document. If I have misstated the issue, please let me know.



The issue of the links not being updated because you are saving them in
different folders is by design. As soon as you change the location of the
linked file, Word will not be able to find it. Word needs to have a file
name and path to be able to update it. One trick you can use to make sure
you are selecting the right link in Edit link for the image you want is to
first select the image, then go to Edit/Links. The link that is highlighted
will be the link to the selected image.



As for the symbols, I was able to reproduce and also reproduce from a Word
file to another Word file. I have submitted a bug report and the developers
will be looking at the report to see if it will be fixed in upcoming
versions of Word.



Please let me know if you have additional questions concerning this issue.



Regards,



Genevieve,

Microsoft Canada

Product Support Services



Customer Satisfaction is our top priority.



We welcome your comments and suggestions on how we can improve the support
we provide to you.



Please e-mail us your suggestions at (e-mail address removed)

You can also contact our Customer Advocate at 1-877-568-2495 ext 82769.



-----------------------------------------------------



Problem Description: Hi Genevieve,



I appreciate that the links are broken and, I guess, I can see why they are
broken "by design" since it means that things have been moved. However, as
all things in life get reorganized in organizations including hard drives
and server files, this requirement to redirect the association of two or
more files and their related links is extremely important to make this
feature usable. Therefore, there has to be a "Macro" or "Global" change
capability to make administration feasible. This is not a "nice to have" but
a "must have" feature to make links manageable.



In addition, the Links window that can be opened for editing cannot be
resized, the columns cannot be resized, there is no scrolling function or
anything to make administration of the existing links even possible without
extreme problems.



These are the more serious aspects of this issue and the problems I face. I
do not think the Links feature is at all well defined or laid out for use.
It appears to be more of an after-thought.



Are there macros or global commands to view, edit, re-direct or recompile
all existing links in a word document as it is move around on drives,
servers, organizational ownerships, etc?



I look forward to hearing about any solutions for right now and in future
upgrades to the links area.



Please let me know



Mickey



-------------------------------------------------------



Hello Mickey,



Unfortunately, there are no utilities that can give you this ability. I
have also consulted our developers to see if I should recommend you open a
professional case to get a sample macro but there are too many variables to
consider this for a VBA sample macro and our Word VBA programmers have run
into many issues with trying to code around this. One thing that is
recommended is to have the same naming convention of the server and
directory structure that you originally had.



There is a 3rd-Party product you might want to consider but as it is not our
product, we do not support it: Crystal Software has created a tool called
WordPipe that can be used to find and replace existing UNC link paths.



Here is their website: http://www.crystalsoftware.com.au



Below is a location to download their evaluation:

<http://www.crystalsoftware.com.au/downloads/download.php?product=WordPipe>



Note: The third-party contact information included in this response is
provided to help you find the technical support you need. This contact
information is subject to change without notice. Microsoft in no way
guarantees the accuracy of this third-party contact information.



On the other hand, I believe enhancing the Edit/Link window to make the
columns resizable and adding a better scrolling function is a good idea. I
have submitted these suggestions internally to improve the future version of
Word. I encourage you to do the same by filling in the following form:



http://register.microsoft.com/mswish/suggestion.asp



Let me know if this helps and if you have additional questions.

Regards,

Genevieve



-----------------------------------------------



Hi Genevieve,



I reviewed the product suggestion and there is no clear indication that the
product actually handles the link editing that is needed. I will try the
demo but the product is too pricey ($250US) for something that I would
expect to be part of the Word functionality.



I have sent off our discussion notes to the suggestion site you identified.
However, I am extremely disappointed that a major functionality that is part
of the Microsoft focus for enterprise support and Office 2002 object sharing
is not going to be fixed right now. I really don't see why this should be
left to some future product.



In any case, there does not seem to be much you or I can do and I am pretty
well stuck. However, I thank you for your efforts.



I will be posting the details of this case to the Word newsgroups to let
others know about the situation and that a possible solution is somewhere in
the future.



Take care,



Mickey
 
C

Cindy Meister -WordMVP-

Hi Mickey

RE the link stuff

1) Make sure all your objects are in-line with the text, no
text wrap formatting applied. If you must have text flow
around objects, then insert them into FRAMES

2) This makes the LINK information directly accessible in
the UI, which means you can get at the field codes. Press
Alt+F9 to turn these on/off.

3) Now, various possibilities are open to you:

- use Find/Replace to change the path of all the links.

- Set up a custom document Property
(File/Properties/Custom) to hold the path information. In
the LINK fields, substitute a DocProperty field for the
hard-coded path. Then you'll only need to change the path
information in this one place and it will propogate through
the fields. (Note: you may need to force the fields to
update.)

- You could also try making sure the option to update links
is activated in Tools/Options/General/Web options/Files.
That this will actually execute with a non-HTML document is
a bug, but no reason you can't take advantage of it if it
will work for you.

- I think you'll find a third-party "link manager" utility
at www.mousetrax.com. I know the utility exists, but I have
no idea whether it has been updated so that it will work
with Word 2002, but it's certainly worth a try. (And since,
last i heard, it was shareware, it would certainly cost
less than USD 250.-)


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:)
 

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