abdb469
asked on
Converting a MS Word excel embedded object back to a spreadsheet
I received a MS Word document with a MS Excel embedded object.
If I double click on the object, I can open the object spreadsheet within word and play with the cells. Is there anyway I can reverse the process so that the object opens as a fully excel spreadsheet in Excel as I want to get access to the spreadsheet and save it as an *.xls file?
I tried coping and pasting after double clicking the object, but its no good.
Thanks.
If I double click on the object, I can open the object spreadsheet within word and play with the cells. Is there anyway I can reverse the process so that the object opens as a fully excel spreadsheet in Excel as I want to get access to the spreadsheet and save it as an *.xls file?
I tried coping and pasting after double clicking the object, but its no good.
Thanks.
Right-click the embedded spreadsheet and select Worksheet Object – Open. You can now copy that and paste it into a new worksheet.
Flyster
Flyster
ASKER
No, that doesn't work. As already explained, I have tried that and it didnt work.
Is your document protected? I was able to take an embedded spreadsheet in Word and copy it to Excel. What versions are you running? Would it be possible for you to post a sample document? Nothing with sensitive information as all posts are opened to the public.
ASKER
The word document is likely to be MS Word 2003 and the embedded spreadsheet will be excel 2003. Unfortunately I cannot post a sample as it contains data in there which is too much to remove.
The document is not protected.
Thx.
The document is not protected.
Thx.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, it works now from home. Not sure why I couldnt get this to work in the office, but this will suffice as I have access to the spreadsheet like you explained.
You're welcome. Glad I could help.
(scroll down to the August 25, 2010 entry, about the middle of the page)
But haven't been able to try it myself yet.