I just spent hours creating a custom function on a spreadsheet WITHOUT transition formula evaluation enabled, and tried to use it on a very complex spreadsheet that has transition formula evaluation enabled. The custom function and other DGET functions stop working with transition formula evaluation enabled. I am VERY concerned about breaking other things in this complex spreadsheet by flipping the formula evaluation switch.

Please help with what this switch does, and possibly how to fix my problem.