Forum Discussion
hernandezt
Oct 20, 2021Copper Contributor
Excel Template
I am using a general ledger with budget comparison template (pic attached). It comes populated up until a certain amount. When I try to add more data, by inserting another row, everything is pasted i...
- Oct 20, 2021It appears you need to:
a) insert a row on the YTD BUDGET SUMMARY tab and fill in the G/L Code, Account Title, and Budget columns
b) insert a row on the MONTHLY EXPENSES SUMMARY tab and fill in the G/L Code, Account Title
c) then you can add the itemized expenses using the G/L code
hernandezt
Jan 21, 2022Copper Contributor
Any way you might know why it suddenly stopped working? Opened it to input more info, and none of the amounts are calculated... not sure why!!
mtarler
Jan 21, 2022Silver Contributor
is the sheet/workbook set to calculate manually? check Formulas - Calculations and try Calculate Now (F9) and check the Options there.
- hernandeztJan 21, 2022Copper ContributorYes, it is. That's why I'm not sure what the problem is
- mtarlerJan 21, 2022Silver ContributorWait, "Yes, it is"? It is set to "Manual"? It needs to be set to "Automatic" for the calculations to automatically update. Also, were there any errors or warning when opening the workbook? For example if there is a circular reference somewhere excel won't calculate (unless you change settings).
- hernandeztJan 21, 2022Copper ContributorApologies, I meant to say that it is set to be automatic. And, no errors, everything was normal!