For our P&L analysis we have a excel spreadsheet embedded into word for some of our figures.

Now I know how to go about putting an excel sheet into word and all of that. However, recently word converts it into a picture file and I can no longer edit the cells. Normally I just double click and it brings up the excel editor. but now when i double click, it brings up the picture properties.

Is there any way to get it back to the excel file instead of completely deleting it and copying and pasting again?


PS I maybe retarded.

Thanks in advance guys!

 

Paste as link???

 

That looks like a Office 2007/2008 document based on the chrome.

After you copy and paste the cells/sheet into Word, a little tooltip icon will show up that looks like the paste icon. Hover over the icon and hit the down arrow. Then select "Keep source formatting and link to excel" or "Match destination table style and link to excel" depending on how you which program you want to use to control the look of the table/cells.

 

An image will not convert back to its original character data without OCR processing. Looks like you're out of luck.

 

 

Sly- Thanks. But I can't seem to get it to pop up when I paste the excel file. It only does it when I pasted text.

Anachostic- Thanks.

 

When I tried to get this to work I was only pasting a certain amount of cells, not an entire worksheet/file. And that may be your problem right there. Only select the cells you need, not the entire worksheet.

I copied an entire worksheet in Excel 2007, and the paste option for me was disabled in Word 2007.

 

^^ Hmm strange, i did the same thing sly and just copied the cells at first.

But just now, i right clicked the excel file itself and copied it. THen pasted in word. Upon right clicking inside the pasted excel file, i have the option for "worksheet object > edit" which allows me to change the excel file.

Are you using office 2k7 quinto?

 

Just send us the file out here and we'll fix it (tell us your company name please).

 

I just tried and it worked, however, the way I'm doing it, is pasting special. So it brings the sheet over.


I am.

That's how it should be, able to edit the sheet right there. Once I edit it, go work on the rest of the document then go back to edit it, its a picture file. I know I'm not converting purposely, just didn't know if there is a setting that does this when I save the doc or what.


Hope I'm not confusing you guys, I'm almost confusing myself.

 

Let me get right on that!

 

Hmm, that is strange. Mine still lets me edit it after I save. But I'm not trying a paste special or anything. i'm just right clicking the excel file itself and copying it, then pasting. I'm running SP2 for office as well. Not sure if that would make the difference either.

 

I didn't know you could copy the actual file in explorer and then paste it. I was right clicking the worksheet tab at the bottom of the excel window and choosing the copy option.

 

Hmm, guess I will just have to keep cutting and paste until I'm done.

Or complete the whole sheet in excel before pasting.


Thanks for all the assistance guys!

 

ok, so I tried RZA's method and i was able to copy the excel file in explorer or on the desktop and paste it into word, but you need to know that there are limitations to this. The main one being if you edit something in your excel file, it won't auto update in your word document. At least it didnt' give me the options for that when I did it.

if you use the method I first mentioned and keep the link to excel intact, you can paste the cells into word go back to your excel document and make changes and the link will help update the information when you close and re-open the word document (it will prompt you if you want to update the excel data though).

Also, in my version of Word 2007, I don't even see a "paste special" option, I remember that used to be in word 2000 though.

 

 

I really hate how they re-worked word and excel. the paste special is under that TINY arrow below the paste button in the upper right hand corner.

 

Yea, it def takes some getting use to.

 

by the arrow. I finally got used to clicking the diagonal arrow for most of the panels to bring up the options for that panel, the down arrow got me on this one.