A calculated column changes a table reference to a cell reference when I reopen the file

I have 2 tables (ADI_Data, Specs) on 2 different sheets(Tracking Data, Specs). The table on the second sheet hold a list of part numbers and specifications and the table on the first sheet is used to enter data for a part number and using calculated columns in that table it uses a VLOOKUP to pull the specs from the table on the second sheet. When I save and close the Workbook the formulas in the cells look like this

Please Login or Register  to view this content.

When I reopen the workbook the formulas now look like this

Please Login or Register  to view this content.

Any idea how to keep this from happening because it keeps me from adding to the Specs table?

I even tried to reference the data itself instead of the whole table

Please Login or Register  to view this content.

but that still changes back to the cell reference.

Sorry, but I can't replicate the behavior.

Can you post the model?

DAC