Solved

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

Posted on 2011-02-23
2
485 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:
teylyn 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Help with Journey Roadmap Graphic 11 47
Weird line on Table of Contents 3 21
Dynamic Excel Countdown Graphic 21 19
onOpen 14 39
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now