I'm using an add-in that I loaded from the Microsoft store to track shipments (UPS, Fedex, USPS, etc.) I have no visibility into the add-in; I give it a tracking number and it returns status, location, etc. I collect all the data in an Excel table after parsing the response. When I get a new shipment to track, I enter the tracking number in a new cell at the bottom of the table and it should populate the rest of that row. The formulas are all there in the new row, but the displayed contents are all #NAME? errors. If I click into any of the error cells, displaying the formula in the formula bar and then just click the green check, the cell calculates and displays the correct value. This used to work properly, but somewhere along the way, something changed and it has not worked for a few months. I'm currently on MS 365 Insider Current Channel, but I've tried non-Insider and Beta without success. After I've gone thru the click cell-then check for some/all of the #NAME? cell and save the file, when I re-open it, the click/saved cells recalc fine but the un-click/saved cells continue to show the #NAME? error.
Any ideas what might be causing this behavior and/or how to fix it? Thanks.
Any ideas what might be causing this behavior and/or how to fix it? Thanks.
