Printing multiple sheets from an Excel spreadsheet embedded in a Word 2007 document
Posted on 2011-02-23
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?