Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-03-21
7
Medium Priority
?
365 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 42

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 42

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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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 42

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 42

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

971 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