A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Formatting Long Documents
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel OLE in Word docs



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2005, 10:25 PM
MLD
external usenet poster
 
Posts: n/a
Default Excel OLE in Word docs

I wasn't sure who would be better to answer this, so I have included both
sides.
In a Win XP/Office 03 Word doc, I am trying to embedded (NOT LINK) a range
of Excel 03 data. It is a 3x38 range. It takes what seems an extra long
period of time for the OLE object to get into the Word doc, but then, I
can't edit it. No matter how much a double click on it, pause, save first -
whatever, it doesn't respond for editing. Since I'm trying to make this into
an interactive template for real estate closings - this is a problem.

Can anyone offer some insight? I don't see anything on OLE limitations.
Thanks,
-Monica




  #2  
Old June 8th, 2005, 01:15 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default

Hi Mld,

I wasn't sure who would be better to answer this, so I have included both
sides.
In a Win XP/Office 03 Word doc, I am trying to embedded (NOT LINK) a range
of Excel 03 data. It is a 3x38 range. It takes what seems an extra long
period of time for the OLE object to get into the Word doc, but then, I
can't edit it. No matter how much a double click on it, pause, save first -
whatever, it doesn't respond for editing. Since I'm trying to make this into
an interactive template for real estate closings - this is a problem.

Can anyone offer some insight? I don't see anything on OLE limitations.

Can you describe the exact commands you're using to insert the object, please.

Do you have any third-party "management" software installed and running, such
as an anti-virus checker? This could be disallowing the OLE link. Try booting
Windows in Safe Mode and see if things work more as you'd expect. If they do,
then start tracking down things that are loading on start up.

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 :-)

  #3  
Old June 8th, 2005, 02:00 PM
MLD
external usenet poster
 
Posts: n/a
Default

Hi Cindy and thank you for responding.
The steps I am using (which typically have always worked for me) a
1. Select the range in Excel, use Ctrl+C to copy.
2. Alt+Tab to move back to my Word doc, use EditPaste SpecialPaste as
Excel Object to paste.

I'm on a Novell network with MS clients and yes, we have McAfee runnning in
the background. I'm not sure I know how to start a Novell box in Safe Mode.

I'll be honest, I don't think that is the problem, as I did a similar doc
with a much larger Excel range a few weeks ago and it still allowed me to
edit. But I'll try disabling the Virus Scan first.
Thanks again,
-Monica




"Cindy M -WordMVP-" wrote in message
news:VA.0000aefb.00de3187@speedy...
Hi Mld,

I wasn't sure who would be better to answer this, so I have included

both
sides.
In a Win XP/Office 03 Word doc, I am trying to embedded (NOT LINK) a

range
of Excel 03 data. It is a 3x38 range. It takes what seems an extra long
period of time for the OLE object to get into the Word doc, but then, I
can't edit it. No matter how much a double click on it, pause, save

first -
whatever, it doesn't respond for editing. Since I'm trying to make this

into
an interactive template for real estate closings - this is a problem.

Can anyone offer some insight? I don't see anything on OLE limitations.

Can you describe the exact commands you're using to insert the object,

please.

Do you have any third-party "management" software installed and running,

such
as an anti-virus checker? This could be disallowing the OLE link. Try

booting
Windows in Safe Mode and see if things work more as you'd expect. If they

do,
then start tracking down things that are loading on start up.

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 :-)



  #4  
Old June 8th, 2005, 02:13 PM
MLD
external usenet poster
 
Posts: n/a
Default

Thankyou all. I think the original files were corrupt in some way. I turned
off McAfee and that still did not work, then tried another set of data,
which caused Word to crash. But I AM able to do InsertObjectNewMS Excel
Worksheet and it is fine. I will just have to retype the information.

Thanx for trying.
-Monica

"Cindy M -WordMVP-" wrote in message
news:VA.0000aefb.00de3187@speedy...
Hi Mld,

I wasn't sure who would be better to answer this, so I have included

both
sides.
In a Win XP/Office 03 Word doc, I am trying to embedded (NOT LINK) a

range
of Excel 03 data. It is a 3x38 range. It takes what seems an extra long
period of time for the OLE object to get into the Word doc, but then, I
can't edit it. No matter how much a double click on it, pause, save

first -
whatever, it doesn't respond for editing. Since I'm trying to make this

into
an interactive template for real estate closings - this is a problem.

Can anyone offer some insight? I don't see anything on OLE limitations.

Can you describe the exact commands you're using to insert the object,

please.

Do you have any third-party "management" software installed and running,

such
as an anti-virus checker? This could be disallowing the OLE link. Try

booting
Windows in Safe Mode and see if things work more as you'd expect. If they

do,
then start tracking down things that are loading on start up.

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 :-)



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The WordPerfect "Reveal Codes" method is so much easier to use. Torden General Discussion 6 April 19th, 2010 07:50 PM
Please give us REVEAL CODES like WORD PERFECT not reveal codes in. Rachel King General Discussion 39 August 21st, 2009 09:54 PM
WP Delay Code - Word Equiv Mike G - Milw, WI General Discussion 6 January 10th, 2005 05:12 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 6th, 2005 12:23 AM
Continuous breaks convert to next page breaks Jennifer Hunt General Discussion 2 December 30th, 2004 06:45 PM


All times are GMT +1. The time now is 11:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.