Thread: Columns in Table have Stopped Auto Calculating?

Hello All,

I have a couple of somewhat related questions...
I have a worksheet with a Table which I have successfully mapped with an XML schema, so I can import data from .xml files into the table easily. This table is named TableA.
In a separate worksheet I have a completely separate table, named TableB, where I have several "calculated columns" which contain formulas with references to columns in TableA.

For example, Column 1 in Table B is a calculated column with the formula:
=IF(TableA[Column1]="someValue", "customValue", TableA[Column1])

Basically, if TableA has a certain value, I want to display something else in TableB, otherwise, just display the same value that is in Table A.

Now, this is a very simplified formula as an example, in reality TableB is full of fairly complicated formulas in each of the columns, usually referencing several columns in TableA. Everything WAS working fine, I would change a formula in 1 cell of a calculated column in TableB, and the rest of the column would update.

But, as I made changes to TableB, like changing the order of the columns, changing the formulas, some of the columns in TableB stopped calculating if I tried to update the formula.

For example, I might have made a change that caused "#REF" to appear in TableB, but when I went to correct the formula, the column would no longer update. In fact, the cell I edited the formula in would just display the literal formula like this:
=IF(TableA[Column1]="someValue", "customValue", TableA[Column1])

I've tried deleting the column from the table and starting from scratch by inserting a new column, but the new column STILL doesn't calculate the entire column, and most times will only display the literal formula like above.

However, if I create an entirely new table and insert the formula, it will work perfectly.
Furthermore, and this is the really weird part, if I right-click in the last column of TableB and insert a new column to the right, the new column will work perfectly as well. But, if I try to insert new columns into the middle of TableB (where the broken columns are), the new columns won't calculate.

Anyone have any clue as to why this is happening, or how to fix it?

Sounds to me as though those columns are specifically formatted as Text. That would certainly explain the formula appearing as literal text.