[teo]

I recently had my laptop stolen and lost a lot of my data. However, I did
have a paper that I e-mailed to someone still in my sent folder. Within that
Word document is a graph that was created based on Excel data. I lost the
excel file with the laptop, but when I go into Word to edit the graph, I can
see the data worksheets as well. However, I am unable to export those
worksheets to a new Excel file or even to copy and paste them.

Is there a way to export the data from within a chart in Word to an Excel
worksheet? I'm using Office 2007.

Thank you!

[Cindy M.]

Hi ?B?VGVv?=,

I recently had my laptop stolen and lost a lot of my data. However, I did
have a paper that I e-mailed to someone still in my sent folder. Within that
Word document is a graph that was created based on Excel data. I lost the
excel file with the laptop, but when I go into Word to edit the graph, I can
see the data worksheets as well. However, I am unable to export those
worksheets to a new Excel file or even to copy and paste them.

Is there a way to export the data from within a chart in Word to an Excel
worksheet? I'm using Office 2007.

I take it you double-click on the graph? And that opens the workbook in the
Word window, with Excel menus? Or in a separate Excel window? If it's not in a
separate Excel window, try right-clicking the graph (instead of double-
clicking) and choose to "Open" (rather than "edit") it. If you're unable to
select the cells with the data, can you see anything in the Protection stuff
that you could "unlock"? (Note that it might be better to ask this in an Excel
group?)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[teo]

Right-clicking and pressing open allowed me to open it in a separate Excel
sheet and I was then able to save all the data. Thank you for your help!!

"Cindy M." wrote:

Hi ?B?VGVv?=,

I recently had my laptop stolen and lost a lot of my data. However, I did
have a paper that I e-mailed to someone still in my sent folder. Within that
Word document is a graph that was created based on Excel data. I lost the
excel file with the laptop, but when I go into Word to edit the graph, I can
see the data worksheets as well. However, I am unable to export those
worksheets to a new Excel file or even to copy and paste them.

Is there a way to export the data from within a chart in Word to an Excel
worksheet? I'm using Office 2007.

I take it you double-click on the graph? And that opens the workbook in the
Word window, with Excel menus? Or in a separate Excel window? If it's not in a
separate Excel window, try right-clicking the graph (instead of double-
clicking) and choose to "Open" (rather than "edit") it. If you're unable to
select the cells with the data, can you see anything in the Protection stuff
that you could "unlock"? (Note that it might be better to ask this in an Excel
group?)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)