Solved

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

Posted on 2012-03-21
7
298 Views
Last Modified: 2012-04-04
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.)
0
Comment
Question by:kdlange77
  • 4
  • 3
7 Comments
 
LVL 41

Expert Comment

by:dlmille
ID: 37751941
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
 

Author Comment

by:kdlange77
ID: 37774017
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
 
LVL 41

Expert Comment

by:dlmille
ID: 37774039
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Accepted Solution

by:
kdlange77 earned 0 total points
ID: 37789112
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
 
LVL 41

Expert Comment

by:dlmille
ID: 37789131
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
 
LVL 41

Expert Comment

by:dlmille
ID: 37789139
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
 

Author Closing Comment

by:kdlange77
ID: 37805204
Case closed.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now