Money in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2786011%22%20slang%3D%22en-US%22%3EMoney%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2786011%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20can't%20get%20the%20spent%20column%20to%20update%20after%20updating%20the%20budget%20column%20in%20the%20monthly%20budget%20template%20inside%20the%20money%20for%20excel%20program.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2786011%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2786052%22%20slang%3D%22en-US%22%3ERe%3A%20Money%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2786052%22%20slang%3D%22en-US%22%3ECurrently%20I%20went%20into%20snapshot%20and%20unhid%20the%20columns%20V-AY%20and%20used%20the%20values%20in%20column%20AD%20in%20a%20simple%20equal%20sign%20to%20move%20the%20spent%20into%20the%20budget%20template.%20It%20doesn't%20update%20when%20switching%20the%20month%20obviously%20but%20its%20a%20rudimentary%20fix%20for%20the%20current%20month%20until%20someone%20can%20help%20me%20with%20a%20permanent%20solution.%3C%2FLINGO-BODY%3E
New Contributor

I can't get the spent column to update after updating the budget column in the monthly budget template inside the money for excel program.

2 Replies
Currently I went into snapshot and unhid the columns V-AY and used the values in column AD in a simple equal sign to move the spent into the budget template. It doesn't update when switching the month obviously but its a rudimentary fix for the current month until someone can help me with a permanent solution.

@jtpolley77 Couple things to try:

  1. Print or copy your monthly amounts, then delete the MonthyBudget tab. This won't affect any other part of the workbook. You can then add it back from the Money in Excel add-in pane, OR:
  2. I normally strongly recommend not changing the structure of the template as provided by Microsoft, but this is safe. The formulas for the "Spent" and "Remaining" columns are the same for every row of the monthly budget table. They do lookups based on the Category name in the first column. If you have a row in the table that is working fine, just copy the spent and remaining cells from that row to a row that is not working.
  3. If step 2 doesn't work, or if the formula is already there, check the spelling of the Category name is the first column.

(Microsoft employee)