Solved

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

Posted on 2011-02-23
2
492 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
[X]
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
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

688 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