Home |
Search |
Today's Posts |
#1
|
|||
|
|||
embedded Excel spreadsheet
Hi, I have a Word doc that has several multiple paged Excel spreadsheets
embedded into it. When I view the document, the only thing I see is page breaks. The spreadsheets do not show. If I used Print Preview, or if I print the doc, they show up. But of course, I cannot edit them. I need to extract the spreadsheets into Excel so that I can manipulate them. How do I do this? I've tried cutting and pasting where the page breaks are, but all this does is bring the spreadsheets over as a graphic image. Thanks! |
#2
|
|||
|
|||
On the View tab of Tools | Options, make sure that "Drawings" is checked and
that "Picture placeholders" is NOT checked. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "rightsidekick" wrote in message ... Hi, I have a Word doc that has several multiple paged Excel spreadsheets embedded into it. When I view the document, the only thing I see is page breaks. The spreadsheets do not show. If I used Print Preview, or if I print the doc, they show up. But of course, I cannot edit them. I need to extract the spreadsheets into Excel so that I can manipulate them. How do I do this? I've tried cutting and pasting where the page breaks are, but all this does is bring the spreadsheets over as a graphic image. Thanks! |
#3
|
|||
|
|||
Thanks Suzanne, I checked that but it's set correctly. I gave up and
manually recreated the spreadsheets since time was of the essence. Thanks for your response. Kathleen "Suzanne S. Barnhill" wrote: On the View tab of Tools | Options, make sure that "Drawings" is checked and that "Picture placeholders" is NOT checked. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "rightsidekick" wrote in message ... Hi, I have a Word doc that has several multiple paged Excel spreadsheets embedded into it. When I view the document, the only thing I see is page breaks. The spreadsheets do not show. If I used Print Preview, or if I print the doc, they show up. But of course, I cannot edit them. I need to extract the spreadsheets into Excel so that I can manipulate them. How do I do this? I've tried cutting and pasting where the page breaks are, but all this does is bring the spreadsheets over as a graphic image. Thanks! |
#4
|
|||
|
|||
Next time... try View - Print Layout.
By the way, you *can* edit in Print Preview. All you have to do is click the Magnifier tool (in the Standard toolbar) to turn the mouse pointer back into a regular editing pointer. That done, right-click the worksheet item and chose Worksheet Object - Edit to edit it in place, or - Open to open a larger Excel window. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. http://www.herbtyson.com "rightsidekick" wrote in message ... Thanks Suzanne, I checked that but it's set correctly. I gave up and manually recreated the spreadsheets since time was of the essence. Thanks for your response. Kathleen "Suzanne S. Barnhill" wrote: On the View tab of Tools | Options, make sure that "Drawings" is checked and that "Picture placeholders" is NOT checked. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "rightsidekick" wrote in message ... Hi, I have a Word doc that has several multiple paged Excel spreadsheets embedded into it. When I view the document, the only thing I see is page breaks. The spreadsheets do not show. If I used Print Preview, or if I print the doc, they show up. But of course, I cannot edit them. I need to extract the spreadsheets into Excel so that I can manipulate them. How do I do this? I've tried cutting and pasting where the page breaks are, but all this does is bring the spreadsheets over as a graphic image. Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting an Excel spreadsheet into Word - how to remove gridl | Tables | |||
Word 2003 with embedded excel spreadsheet | Microsoft Word Help | |||
How do I block a user from opening an excel spreadsheet in word? | Microsoft Word Help | |||
Embedded Excel Spreadsheet Corrupted | Microsoft Word Help | |||
Embedded Excel spreadsheets in Word | Microsoft Word Help |