Files w/ Custom Streaming Functions that shows #NAME? persists even if Add-in is Successfully loaded #6355
Description
When opening a file that has a previously #NAME? error in a custom streaming function the error does not automatically go away even though the functions definition and the add-in has been successfully loaded. It's confirmed that the function definition has been loaded because adding the same custom streaming function in the file would not result in a #NAME? error.
newly added custom streaming function shows #VALUE and the same streaming function that was previously left in a #NAME? error state remains showing the error
newly added custom streaming function now resolves to a value after user authenticates in the add-in but the same streaming functions in a different cell remain in a #NAME? error state
The expected behavior here is that the values should automatically change from #NAME? to the data value of the custom streaming function, once the add-in has been loaded. The workaround for this is to manually re-enter the cells that shows #NAME? error or hit ctrl + h and replace all the streaming function w/ the same streaming function to force mimic a recalc on the cells that shows the error. To add more details here the cells containing the custom streaming function, even the cells that shows a #NAME? error, are recalculated once users authenticate in the add-in but the error still persists.
What could be causing this issue? Is there a way for the Office/Excel to detect cells containing the custom streaming function that have previously shown a #NAME? error and re-evaluate those again once the add-in and custom streaming definition has been loaded?