Turn Off Calculated Columns

Hello Everyone,

 

I have a workbook with multiple sheets with a different table on each one. A lot of the columns needs consistent formulas and so calculated columns are great for this. However, some of the columns I don't want to have this enabled. It seems that any column that I would like this feature to work didn't work originally, and the columns that I don't want to use it with, it's working with.

 

I've figured out to make an existing column work when it didn't originally, I just have to make sure all the cells in that column have the same type of formula. However, as far as I can tell, once you set it up like that, you can't break it. 

 

For example: I have a column that will automatically create a hyperlink to another part of the workbook. When I would create another row in the table, it wouldn't copy that formula. After making sure every cell in that column had the same formula structure, it works now. Elsewhere in the workbook (even in the same table), I have a column that also creates a hyperlink to somewhere else in the workbook. However, not ever cell in these columns has the same formula structures. Yet when I create a new row, it still copies down the formula. 

 

Is there a way to stop this from happening?