how do I edit an embedded spreadsheet?

L

lldelk

I recently received a "leads list", created in Excel, which consists of one
spreadsheet embedded into another. The embedded spreadsheet appears to be
very large (over 1000 printed pages) and contains a lot of irrelevant
information that I would like to edit out, however, I am unable to select any
of that information. Can someone please tell me how to edit an embedded
spreadsheet or at least un-embed it so I can use it? Thanks!
 
L

lldelk

I'm not entirely sure what's going on with it, but when I attempt to click on
any of the information, the formula bar reads "=EMBED("Excel.Sheet.8","")".
 
D

Dave F

It sounds like someone pasted one excel document into another, as opposed to
the data itself.

Not sure how you would edit that.

Maybe ask the person from whom you received the document to send you only
the original source document, and not to embed it in another document.
 
S

SimonCC

Have you tried just double clicking the embedded object? The object should
just open up as a sheet for you to edit.
 
L

lldelk

That worked, and I now have a usable spreadsheet.
Thank you! Thank you! Thank you! Simon, you are my new hero!

Lisa
 
L

lldelk

Thanks for trying to help Dave! SimonCC suggested I double click the
embedded portion, and when I did, it opened right up. Thought you'd want to
know in case you ever run across it again.

Lisa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top