Locking tabs in a workbook.

%3CLINGO-SUB%20id%3D%22lingo-sub-2888163%22%20slang%3D%22en-US%22%3ELocking%20tabs%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888163%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20I%20use%20to%20track%20our%20load%20pays%20for%20payroll.%26nbsp%3B%20I%20have%20tabs%20that%20signify%20each%20payroll%20period%20and%20a%20tab%20that%20has%20all%20of%20the%20loads%2C%20their%20pay%20and%20W%2FC%20Code.%26nbsp%3B%20I%20have%20to%20change%20rates%20for%20some%20of%20the%20loads.%26nbsp%3B%20If%20I%20change%20it%20in%20the%20load%20list%20page%20it%20changes%20all%20previous%20pay%20period%20totals%20that%20had%20those%20loads%20hauled.%26nbsp%3B%20This%20throws%20off%20my%20payroll%20for%20year%20end.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20lock%20previous%20pay%20period%20tabs%2C%20so%20those%20amounts%20won't%20change%3F%26nbsp%3B%20I%20don't%20really%20want%20to%20start%20adding%20more%20of%20the%20same%20loads%2C%20just%20putting%202021%20after%20them.%26nbsp%3B%20For%20instance%2C%20OC%20-%20Dila%20Dairy%20vs.%20OC%20-%20Dila%20Dairy%202021.%26nbsp%3B%20This%20just%20adds%20too%20many%20loads%20I%20have%20to%20sort%20through%20when%20entering%20time%20cards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense%20and%20that%20there%20is%20a%20simple%20solution.%26nbsp%3B%20Thank%20you%20for%20any%20all%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERandy%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2888163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2888284%22%20slang%3D%22en-US%22%3ERe%3A%20Locking%20tabs%20in%20a%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888284%22%20slang%3D%22en-US%22%3EThe%20simple%20answer%20is%20you%20have%20a%20couple%20options%3A%3CBR%20%2F%3Ea)%20after%20the%20year%20end%20you%20copy%20all%20the%20a%20and%20paste%20it%20into%20a%20new%20sheet%20as%20'Values%20Only'%3CBR%20%2F%3Eb)%20you%20have%20a%20look%20up%20table%20for%20ongoing%20OC%20values%20so%20you%20track%20them%20over%20the%20years%20(not%20much%20different%20than%20renaming%20each)%3CBR%20%2F%3Ec)%20a%20sort%20of%20hybrid%20where%20on%20each%20sheet%20you%20have%20an%20OC%20value%20cell(s)%20that%20reference%20the%20other%20sheet%20(basically%20just%20mirrors%20that%20value%20through%20the%20year%20as%20you%20track%20it%20on%20the%20other%20sheet)%20but%20at%20the%20end%20of%20the%20year%2Fperiod%20you%20'LOCK'%20them%20in%20by%20copying%20that%20cell(s)%20on%20this%20sheet%20and%20then%20paste%20'Values%20Only'%20over%20top%20that%20cell%20to%20wipe%20out%20the%20formula%20and%20fix%20the%20value(s)%20on%20this%20sheet%20but%20the%20other%20sheets%20are%20not%20affected.%3C%2FLINGO-BODY%3E
New Contributor

I have a spreadsheet that I use to track our load pays for payroll.  I have tabs that signify each payroll period and a tab that has all of the loads, their pay and W/C Code.  I have to change rates for some of the loads.  If I change it in the load list page it changes all previous pay period totals that had those loads hauled.  This throws off my payroll for year end. 

 

Is there a way to lock previous pay period tabs, so those amounts won't change?  I don't really want to start adding more of the same loads, just putting 2021 after them.  For instance, OC - Dila Dairy vs. OC - Dila Dairy 2021.  This just adds too many loads I have to sort through when entering time cards.

 

Hope this makes sense and that there is a simple solution.  Thank you for any all info.

 

Randy  

2 Replies
The simple answer is you have a couple options:
a) after the year end you copy all the a and paste it into a new sheet as 'Values Only'
b) you have a look up table for ongoing OC values so you track them over the years (not much different than renaming each)
c) a sort of hybrid where on each sheet you have an OC value cell(s) that reference the other sheet (basically just mirrors that value through the year as you track it on the other sheet) but at the end of the year/period you 'LOCK' them in by copying that cell(s) on this sheet and then paste 'Values Only' over top that cell to wipe out the formula and fix the value(s) on this sheet but the other sheets are not affected.

@mtarler - Never thought of copying and pasting into another sheet.  I guess that would be easiest.  I'll start that and if there is a "lock" tab way to do it later, I can always change.

 

Thanks.