please attach your xls template and maybe xls with what you are trying to achieve. That would help recognise your problem better.
on the other hand i am not sure whether you can refer to table object as such. Excel calcualtion is done on row level so creating new calculated column has be done on the same level.\
If I use =right(B2,2) function in my Excel template Table Object
only first row in Column C gets populated as a result of excel formula not all rows
How can I get all rows in Column C to be populated?
Column A Column B Column C Vendor Week Year HP W35-16 16 HP W35-13 HP W36-16 HP W36-16 HP W37-17 HP W37-16 HP W38-15 HP W38-16 HP W39-14