I have some problems with lookup tables since the last office update. I am using the 2D Lookup format in my Worksheet.
table #TireF = E:\Pi Daten\CalcTablePi.xlsx\Calc!E17:G22;
#TireF (CONST(RR),[Tire RR],Both)+CONST(staticRR)
It was woking very well since 2018 and i havn't changed anything either on the worksheet itself or the excel sheet. But now, as I was looking through the sheets, I noticed, that I got the response "No Value". The channel [Tire RR] is working well. also the constants are set and are within the limits of the lookup table.
to try a simple way of a lookup table, i was setting the lookups static:
Now it should display the value of x=3 and y=2000. It also returns me "No Value". While searching for a suggestion, I was also checking old data where this worksheet was definitely working with. Also "No Value". I am using Pi Toolbox 7.3 and I have also checked it with Pi Toolbox 11.0.
(Win10 1903 built 18362.900; Excel 2016 release 2005)
Has somebody a similar problem? Can somebody help me regarding this problem?