[rwr]

Fred Borden wrote:
Thanks for the reply, but I guess I was not clear, or perhaps incorrect
regarding embedding. Maybe that is what I am doing. First, the worksheet
already exists in my document template. What I do is copy a table from excel
that is in the same format as in the word worksheet object. I then open the
Word worksheet object, choose Paste Special, then choose values. The new
values are then in Word. I then close out of the worksheet object. At some
point thereafter, when I try to go back into that same worksheet object, I
find that it is now just an Object and I am unable to to edit. When I right
click and choose Object, I get the message "This object is corrupt or no
longer available". I do not understand what is causing the worksheet object
to convert to an object.

"macropod" wrote:

Hi Fred,

It all depends on which format you chose. You say you didn't want to embed the worksheet, so the only other way is to insert it as
another kind of object (eg picture). An alternative would be to insert a link to the object, in which case you'd normally do the
editing in the source worksheet, not in Word.

Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

"Fred Borden" wrote in message ...
I have Office 2003. I have been copying tables from excel into word. I first
insert an Excel spreadsheet into Word, then copy a table from Excel. I then
Paste Special, choose values, then choose formats. This works out fine,
initially. Now though, when I need to go back in to edit a spread is Word, I
double click and find that my worksheet object hast become an object. I then
can't edit and have to start all over. What is casuing the worksheeet object
to become an object? Also, when I right click and choose "Object", I get a
message that says "This object is corrupt or no longer available". Note that
for size reasons, I do not want to imbed the worksheet into Word. I never
had this problem with Office 97.


You may have something else wrong or going on with your software.
If I do the following it works. I'm using Office 2003

1. Add an Excel object to a word doc. Insert/Object/Create New
Object/Select Microsoft Excel Worksheet.
2. Copy some cells from an Excel Worksheet
3. Do a Paste Special values only into the object in word.
4. Click away from the object in word.
5. Close or do not close excel, both cases work.
6. Double click the object in word.
7. The Excel formula bar opens up in the toolbar area.
8. I can click into the formula bar or double click a cell and I can
edit the data.

Your comment "worksheet object hast become an object", seems to me it
should stay an object. Other variations of copy/paste from Excel would
put the Excel data into a Word table, which you should still be able to
edit the table. The only time, in my experience, you can't edit the data
is if you copy Excel cells and then do a paste special and select
Bitmap, Picture (Windows Metafile) or Picture (Enhanced Metafile).

Ron