?
Solved

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

Posted on 2011-02-23
2
Medium Priority
?
493 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

752 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