Sharing only 1 sheet of a notebook

%3CLINGO-SUB%20id%3D%22lingo-sub-2057839%22%20slang%3D%22en-US%22%3ESharing%20only%201%20sheet%20of%20a%20notebook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057839%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20bi-weekly%20schedule%20changes%20that%20I%20send%20to%20Payroll%20set%20up%20in%20a%20notebook%2C%20each%20pay%20period%20on%20a%20separate%20sheet.%26nbsp%3B%20I%20need%20to%20send%20them%20the%20sheet%20with%20the%20current%20changes%2C%20but%20they%20do%20not%20need%20the%20previous%20sheets.%26nbsp%3B%20I%20do%20not%20want%20to%20do%20a%20separate%20notebook%20for%20each%20pay%20period.%26nbsp%3B%20How%20can%20I%20just%20send%20a%20specific%20sheet%2C%20without%20sending%20the%20whole%20book%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2057839%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2058855%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20only%201%20sheet%20of%20a%20notebook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058855%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928063%22%20target%3D%22_blank%22%3E%40Middleton560%3C%2FA%3E%26nbsp%3BThere%20is%20no%20way%20to%20send%20a%20single%20tab%20from%20a%20workbook.%20The%20alternative%20is%20to%20%22automate%22%20the%20generation%20of%20a%20new%20workbook%20to%20save%20a%20couple%20minutes.%20Some%20questions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20the%20new%20sheet%20reference%20the%20previous%20sheets%3F%3C%2FP%3E%3CP%3EDoes%20the%20file%20require%20the%20formulas%20to%20be%20intact%20or%20can%20final%20figures%20be%20sent%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2058997%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20only%201%20sheet%20of%20a%20notebook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20usually%20send%20it%20in%20PDF%20format%2C%20as%20that%20seems%20to%20work%20best%20on%20everyone's%20devices%20and%20it's%20informational%20only%2C%20some%20of%20them%20are%20checking%20it%20out%20on%20their%20phones.%26nbsp%3B%20Which%20is%20why%20they%20don't%20need%20any%20earlier%20sheets%2C%20it%20just%20bulks%20up%20the%20file.%3C%2FP%3E%3CP%3EIn%20a%20setup%20like%20this%20I%20don't%20usually%20string%20formulas%20between%20sheets.%3C%2FP%3E%3CP%3EI'm%20assuming%20I'll%20just%20have%20to%20create%20a%20temp%20book%20with%20just%20the%20sheet%20I%20want%20to%20send.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have bi-weekly schedule changes that I send to Payroll set up in a notebook, each pay period on a separate sheet.  I need to send them the sheet with the current changes, but they do not need the previous sheets.  I do not want to do a separate notebook for each pay period.  How can I just send a specific sheet, without sending the whole book?

3 Replies

@Middleton560 There is no way to send a single tab from a workbook. The alternative is to "automate" the generation of a new workbook to save a couple minutes. Some questions:

 

Does the new sheet reference the previous sheets?

Does the file require the formulas to be intact or can final figures be sent?

@adversi 

I usually send it in PDF format, as that seems to work best on everyone's devices and it's informational only, some of them are checking it out on their phones.  Which is why they don't need any earlier sheets, it just bulks up the file.

In a setup like this I don't usually string formulas between sheets.

I'm assuming I'll just have to create a temp book with just the sheet I want to send.

@Middleton560 If that's the case, choose to Print (Ctrl + P) and select the Print to PDF for Active Sheet (which is the current sheet you are viewing) 

 

adversi_0-1610582891618.png

 

This should resolve your issue, and to control the format for the print, you can use the Page Break Preview 

adversi_1-1610582947082.png