Word 2007 linked document opens differently in Remote Desktop and directly from a Desktop

I have a Word 2007 document with links to an Excel file.  These links point to a source file that is not available.  This file is also about 2mb in size.  When I try to open directly from my Word 2007 program from my local desktop, it takes between 2-4 hours to open.  If I try to end the open before it is done, I get catastrophic failures in document.xml, yada yada yada.  
However, if I open the exact same file in a Remote Desktop session using the Word 2007 program on the Remote Desktop Server, it opens in less than a minute...and the links are just as invalid here as they are on my desktop.  Breaking the links and saving the file in either location fixes "the problem"...I just don't understand why the time it takes to open in each location is so drastically different...can anyone explain this to me?  (BTW...the option to "Update automatic links at open" have no effect on the process either way...checked or unchecked makes no difference.)
kdlange77Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dlmilleCommented:
I'm personally not a big fan of this type of linkage, embedded or otherwise - perhaps I've never had a lot of luck, and embedded just adds the weight of the excel file to the Word document as well.

However, you state the source file is not available.  You state that you have (when the file ultimately opens) changed the link behavior to update manually rather than automatic?  This may improve the "load time" of the Word document.  I'm surprised if you have and saved and seen no benefit as a result of going to manual update.

It may be possible that the Word document is corrupt, in which case perhaps a copy/paste/recreation of the Word document could be in order.

-------------------------------------------------
In the meantime, you might enjoy this related article which you may find very relevant, as it gives you a utility to update Word documents from Excel pasting images (as opposed to linking).  If you think it helpful, a YES vote is appreciated.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_8933-How-to-quickly-and-accurately-populate-Word-documents-with-Excel-data-charts-and-images-including-Automated-Bookmark-generation.html

The driver from the articles' perspective is Excel, so when Excel data is updated, you can kick off the macros to update the word document, thus all viewing Word don't have to go through the link process.

Cheers,

Dave
0
kdlange77Author Commented:
Thanks for the info Dave, but I'm afraid that was no help.  I am just closing  the question and chalking this up to the fact that Microsoft has something going on in the background that changes the behavior of the program with this issue when installed in Remote Desktop mode.
0
dlmilleCommented:
Before you close out/delete the question (fine by me), you might try one thing:

1.  Are you logging into the Remote Desktop with the same user profile?
2.  Are the network shares the same in your normal login and that of the Remote Desktop?  Are the same UNC paths available, and/or are the same network drive shares available?
3.  If the remote desktop is at a different installation than your current login location (e.g., the server is located and accessed by additional internet "hops", this could be causing the delay.

If the answer is no to 1 and/or 2, you might try it ensuring consistency.

If #3 is yes, then that might be your answer as well.

I use Remote Desktop on a daily basis and have not seen this particular issue, though can anticipate it if the paths/shares are different, or my server location is at a distant location when remoting in.

If this is no help and you want to can the question, please don't award points, just delete the question as there's no solution here worth saving in the knowledgebase.

Dave
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

kdlange77Author Commented:
1. I am logging in with the same user account on the network, but we do not use roaming profiles so the user profile is different by design in the local environment from the user profile in the Remote Desktop server environment.  
2. The same mapping and UNC availability logging in locally or via Remote.
3. Not applicable.

Sorry...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dlmilleCommented:
Sorry on my end as well.

Profile might be the issue, but no overcoming that I expect.

If your remote desktop is in the same location, I recommend one more test.  Grant access for remoting into your machine, go to a colleagues machine and remote in.  Does that remote desktop adventure work the same as locally logging in or the same as your current remote desktop experience?

Once we've answered that, (if it is different) if you have the energy, we might have a nugget of insight to help solve the problem.

Dave
0
dlmilleCommented:
Independent of the status of this question, I do encourage this last test.  The amount of time you spend waiting on the remote desktop warrants one more test, you think?

Dave
0
kdlange77Author Commented:
Case closed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.