adding ROWS to the spreadsheet https://templates.office.com/en-us/Business-expense-budget-TM04035489

%3CLINGO-SUB%20id%3D%22lingo-sub-3453228%22%20slang%3D%22en-US%22%3Eadding%20ROWS%20to%20the%20spreadsheet%20%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM04035489%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM04035489%3C%2FA%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3453228%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20use%20the%20template%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM04035489%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM04035489%3C%2FA%3E.%26nbsp%3B%20I%20require%20additional%20ROWS%20for%20data%20is%20several%20of%20the%20tables.%26nbsp%3B%20%26nbsp%3BI%20am%20unable%20to%20accomplish%20this%20task%20and%20maintain%20some%20formulas%2Ftotals.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20these%20Pivot%20tables%20%3F%26nbsp%3B%20%26nbsp%3BI%20have%20tried%20to%20research%20ADDING%20ROWS%20which%20I%20know%20how%20to%20complete%20in%20a%20basic%20spreadsheet%20-%20this%20has%20me%20frustrated%20though.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3453228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3453511%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20ROWS%20to%20the%20spreadsheet%20%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM0403%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM0403%3C%2FA%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3453511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1409518%22%20target%3D%22_blank%22%3E%40rosbo1%3C%2FA%3E%26nbsp%3BQuite%20a%20fancy%20template.%20Lots%20of%20colors%20which%20are%20almost%20painful%20to%20the%20eye.%20But%20the%20good%20thing%20is%20that%20it%20uses%20structured%20tables.%20On%20the%20Start%20page%20they%20suggest%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376635i67416BF5C1EFF639%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20alt%3D%22Screenshot%202022-06-01%20at%2007.50.38.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOn%20the%202nd%20sheet%20there%20is%20a%20note%20telling%20you%20what%20to%20do%20if%20you%20want%20to%20add%20rows.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20style%3D%22width%3A%20143px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20style%3D%22width%3A%20143px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20style%3D%22width%3A%20143px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20style%3D%22width%3A%20143px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20style%3D%22width%3A%20143px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376634i57D2C8F1DFD4772E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20alt%3D%22Screenshot%202022-06-01%20at%2007.43.31.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESo%2C%20on%20the%20Planned%2C%20Actual%20and%20Variances%20sheets%20you%20can%20add%20rows%20within%20each%20of%20the%20tables%20but%20you%20have%20to%20do%20that%20in%20each%20of%20the%20sheets%20and%20the%20inserted%20rows%20have%20to%20in%20the%20same%20place.%3C%2FP%3E%3CP%3EThe%20template%20gives%20you%20four%20expanse%20categories%2C%20each%20with%20its%20own%20table%20in%20three%20separate%20sheets.%20Then%20the%20Analysis%20sheet%20links%20to%20these%20tables.%20If%20you%20would%20want%20to%20add%20an%20expense%20category%2C%20you%20need%20to%20create%20a%20table%20for%20it%20in%20each%20of%20the%20sheets%20in%20a%20similar%20way%20as%20the%20current%20tables.%20Then%20add%20a%20row%20to%20the%20analysis%20table%2C%20manually%20link%20the%20correct%20cells%20and%20make%20sure%20that%20the%20graphs%20are%20updated%20correctly.%20All%20in%20all%2C%20quite%20a%20lot%20of%20work%20for%20an%20otherwise%20not%20very%20useful%20template.%20But%20that's%20just%20my%20personal%20opinion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3456709%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20ROWS%20to%20the%20spreadsheet%20%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM0403%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM0403%3C%2FA%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3456709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20for%20the%20reply.%3CBR%20%2F%3EI%20reached%20out%20to%20the%20community%20after%20I%20was%20unable%20to%20perform%20the%20list%20of%20help%20items%20noted%20on%20the%20spreadsheet%20template%20.%26nbsp%3B%3CBR%20%2F%3EThanks%20for%20taking%20a%20look%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3456721%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20ROWS%20to%20the%20spreadsheet%20%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM0403%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2FBusiness-expense-budget-TM0403%3C%2FA%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3456721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1409518%22%20target%3D%22_blank%22%3E%40rosbo1%3C%2FA%3E%26nbsp%3BOkay!%20Just%20wanted%20to%20make%20clear%20that%20it%20take%20quite%20an%20effort%20to%20adjust%20such%20a%20template.%20The%20are%20designed%20to%20be%20used%20as%20is.%20If%20you%20can%20specify%20what%20exactly%20you%20want%20to%20change%20I%20can%20see%20what%20I%20can%20do.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I would like to use the template https://templates.office.com/en-us/Business-expense-budget-TM04035489.  I require additional ROWS for data is several of the tables.   I am unable to accomplish this task and maintain some formulas/totals.   

Are these Pivot tables ?   I have tried to research ADDING ROWS which I know how to complete in a basic spreadsheet - this has me frustrated though. 

3 Replies

@rosbo1 Quite a fancy template. Lots of colors which are almost painful to the eye. But the good thing is that it uses structured tables. On the Start page they suggest this:

Screenshot 2022-06-01 at 07.50.38.png

On the 2nd sheet there is a note telling you what to do if you want to add rows.

Screenshot 2022-06-01 at 07.43.31.png

So, on the Planned, Actual and Variances sheets you can add rows within each of the tables but you have to do that in each of the sheets and the inserted rows have to in the same place.

The template gives you four expanse categories, each with its own table in three separate sheets. Then the Analysis sheet links to these tables. If you would want to add an expense category, you need to create a table for it in each of the sheets in a similar way as the current tables. Then add a row to the analysis table, manually link the correct cells and make sure that the graphs are updated correctly. All in all, quite a lot of work for an otherwise not very useful template. But that's just my personal opinion.

@Riny_van_Eekelen Thank you for the reply.
I reached out to the community after I was unable to perform the list of help items noted on the spreadsheet template . 
Thanks for taking a look 

@rosbo1 Okay! Just wanted to make clear that it take quite an effort to adjust such a template. The are designed to be used as is. If you can specify what exactly you want to change I can see what I can do.