Data Table - Make lookup mode trigger on new key value.

earl_bennett

It's 2024 and returning data from a lookup query shouldn't take 4 to 5 minutes. It's my understanding that DataTable refreshes every 5 minutes by design. Please change this when in Lookup Mode. When a user enters a key value, that action should trigger the refresh/lookup.

It's ridiculous for a user to have to wait up to 5 minutes.
* Change lookup mode to trigger on sheet value entry/change
* Open the data table for direct access