Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

618 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