Forum Discussion
Solved
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...
- It 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
It 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
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
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!!
- is the sheet/workbook set to calculate manually? check Formulas - Calculations and try Calculate Now (F9) and check the Options there.
- Yes, it is. That's why I'm not sure what the problem is
- Wait, "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).