Spreadsheet formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1766025%22%20slang%3D%22en-US%22%3ESpreadsheet%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766025%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20years%2C%20I%20have%20done%20my%20budget%20using%20a%20spreadsheet.%20One%20spreadsheet%20per%20year%2C%20one%20sheet%20per%20month.%20At%20the%20end%20of%20the%20month%2C%20I%20copy%20the%20last%20sheet%20into%20the%20next%20new%20sheet.%20For%20example%2C%20the%20Nov.%20sheet%20into%20the%20Dec.%20sheet%2C%20and%20rename%20the%20new%20sheet.%20I%20then%20clear%20all%20amounts%20on%20the%20new%20sheet%2C%20allowing%20the%20totals%20to%20revert%20to%20zero%20to%20start%20over%20again%20with%20the%20next%20month.%20As%20of%20last%20month%20when%20I%20did%20this%2C%20the%20totals%20didn't%20change%20when%20I%20cleared%20the%20column%20amounts%20under%20each%20of%20the%20budget%20headings.%20I've%20tried%20everything.%20The%20totals%20remain%20the%20same%20even%20if%20I%20clear%20the%20columns%20down%20to%20nothing.%20I've%20tried%20creating%20a%20new%20spreadsheet%20entirely%20and%20the%20same%20thing%20happens.%20Please%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766087%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826903%22%20target%3D%22_blank%22%3E%40smuggler0427%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20Calculation%20Options%20is%20set%20to%20Automatic%20in%20the%20Calculation%20group%20of%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

For years, I have done my budget using a spreadsheet. One spreadsheet per year, one sheet per month. At the end of the month, I copy the last sheet into the next new sheet. For example, the Nov. sheet into the Dec. sheet, and rename the new sheet. I then clear all amounts on the new sheet, allowing the totals to revert to zero to start over again with the next month. As of last month when I did this, the totals didn't change when I cleared the column amounts under each of the budget headings. I've tried everything. The totals remain the same even if I clear the columns down to nothing. I've tried creating a new spreadsheet entirely and the same thing happens. Please help!

1 Reply

@smuggler0427 

Make sure that Calculation Options is set to Automatic in the Calculation group of the Formulas tab of the ribbon.