Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Printing multiple sheets from an Excel spreadsheet embedded in a Word 2007 document

Posted on 2011-02-23
2
489 Views
Last Modified: 2012-06-22
I have a Word 2007 document that includes an embedded Excel 2007 spreadsheet.  The spreadsheet has multiple work sheets (tabs).  It can be opened and updated just fine, but when printing the Word document, only the current sheet (whatever one is left selected when returning to the Word document) actually prints.  I would like it to print all of the work sheets, not just the currently active one.  I have tried selecting all tabs (group select), then going out to the Word document and printing - same problem, only the currently selected work sheet prints.  ... I know in Excel I can print all work sheets in a particluar spreadsheet through various means.  I can't seem to get any of them to work when the Excel spreadsheet is embedded in a Word document.  Any suggestions?
0
Comment
Question by:michko
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 34965245
Hello,

Word is WYSIWYG. What you see on the screen is what will be printed. If you need several different sheets of an embedded Excel file printed, then you need to create embedded objects for each of these Excel sheets.

Or, bring the sheets to the front one by one and print the current page of the Word document until you have printed all sheets.

cheers, teylyn
0
 
LVL 27

Author Comment

by:michko
ID: 34965436
I was afraid that was the answer I was going to receive, but was holding out some hope I would get lucky.

Seems silly to me that I can print all the worksheets in the same workbook opened only in Excel, but when it gets embeded that functionality goes away.  I wouldn't have thought it that hard to include - and potentially quite useful.

I can embed each worksheet separately, but it will be a bit more work to set up and maintain.  

Hmmm, I may need to rethink a few things.

Thanks for your answer teylyn, much appreciated.


0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question