#1   Report Post  
sumtop
 
Posts: n/a
Default OLE Issue

We have a lots of Word documents with embeded excel documents. Sometimes
when we open a Word document it gives us two prompts about updating the data
that is linked to Excel. If we say yes to both prompts then when we double
click on the Excel table in Word it say that it is already open and the we
may loss data. We can still open it and edit it, but why are we getting this
message? Why is the Excel sheet opening up before we click on it?
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?c3VtdG9w?=,

We have a lots of Word documents with embeded excel documents. Sometimes
when we open a Word document it gives us two prompts about updating the data
that is linked to Excel. If we say yes to both prompts then when we double
click on the Excel table in Word it say that it is already open and the we
may loss data. We can still open it and edit it, but why are we getting this
message? Why is the Excel sheet opening up before we click on it?

Which version of Word is involved, here? Do you have any file/document
management or anti-virus software active? If you deactivate it, do you see
anything different?

Background: In Word 2003 and most recent version service packs new security
features disable automatic link updates. If you have this option activated in
Tools/Options/General you'll get a prompt about updating the fields. This is
normal behavior. When Word updates an OLE object, the server application is
opened in the background.

But after the update takes place, it should be closed. Something is apparently
preventing this, and the "usual suspects" would be programs that track files...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Custom paper size printing issue Brad Zenner Page Layout 2 March 3rd 05 07:25 PM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 16th 05 12:38 AM
Mail merge Deployment issue with ASP.net and alternative ?? sanjeeev Mailmerge 1 February 14th 05 09:27 PM
Issue when querying excel 2003 to merge into word 2003 Chris Schilling Mailmerge 3 December 7th 04 09:22 PM


All times are GMT +1. The time now is 03:24 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"