My table formula won't grow with the table

[kctony]

I have a table that I have saved as a Template.
When I add the template to a new workbook the first calculated row works but nothing after that.
I can add data and the table will grow but the formula won't follow it.
Is it because it's a template?
Why is this happening?
I can't use xl2bb because it is not a valid add-in. It may be blocked at my work.

 

[kctony]

I have a table that I have saved as a Template.
When I add the template to a new workbook the first calculated row works but nothing after that.
I can add data and the table will grow but the formula won't follow it.
Is it because it's a template?
Why is this happening?
I can't use xl2bb because it is not a valid add-in. It may be blocked at my work.

 

[kctony]

OK, I was able to download and use xl2bb once I got home. Must be blocked at work.

NarcoticLog.xlsx
	G	H	I	J	K	L	M	N	O	P
2	Received			Dispensed
3
4	Transaction Date	NDC	Amount Received	Transaction Date2	Rx #	NDC3	Amount Dispensed	Verified	Total on Hand	Comments
5										Starting amount
6									0
7
Sheet2

Cell Formulas
Range	Formula
O6	O6	=IF([@[Amount Received]]<>"",OFFSET([@[Total on Hand]],-1,0)+[@[Amount Received]],OFFSET([@[Total on Hand]],-1,0)-[@[Amount Dispensed]])

 

[kctony]

Never mind... I figured it out.
Apparently, you can't build a formula then make a table. You have to make a table Then build the formula.
Thanx