After saving my excel spreadsheet has turned into an embedded object

[MOONDRIFT47]

My colleague has saved an excel file but when he opens it he can no longer edit it. Where the cell number appears it says object 1 and the formula bar reads =Embed("excel.sheet.12","") can someone tell me why this happens just by saving and reoppening the file?

Thank you

[romperstomper]

You should only see a formula like that if you inserted one workbook as an object into another.

[MOONDRIFT47]

I know, that is what I can not understand. Literally all that happened was the workbook was saved on a usb drive, then reopened and it opened in this way

[romperstomper]

I can't say I've ever heard of that before. Can you post the workbook?

[MOONDRIFT47]

unfortunately its 10mb so unable to do so. He sent it to me and I opened it and it resembles a modern art picture. I do not understand why this only happens on his excel.

[romperstomper]

What version is he using?

[MOONDRIFT47]

excel 2007 i am using 2013

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[MOONDRIFT47]

I wonder if it is because it is being saved on an external drive?

[romperstomper]

That shouldn't cause what you are describing.

[MOONDRIFT47]

it seems to happen after the sheet is copied and then paste special is selected to retain formulas. The resulting sheet comes up as an embedded object......

[AliGW]

Please attach a workbook, as requested in post #8.

[MOONDRIFT47]

I can not attach workbook as it is 10mb

[AliGW]

Can you provide a smaller sample file that displays the same behaviour?

[MOONDRIFT47]

Hi, It is not doing it on my version of excel only on the 2007 version. so I do not think there is anything anyone can help with, but thank you anyway. I cannot give a smaller version of the file.

[romperstomper]

It sounds like your colleague is copying between two separate instances of Excel, and then choosing "Microsoft Excel Worksheet Object" in the Paste Special dialog.

[MOONDRIFT47]

ok, i will tell him about that and see what happens. Thank you. Rep added.

[romperstomper]

Thanks.