Hi,
We're using a workbook with a bunch of queries in it. Every query has a lot of variables declared that are calculated based on two input ready variable that users are required to fill the first time.
Everything works as expected until the save data function is called, which in turn calls the planning function.
Here, the user exit variable try to be recalculated again. Unfortunately, this planning function loses track of the two input ready variables that were on the workbook, so the user exit variables have no values.
Can you please suggest a method so that:
a) The user exit processing in the planning function "sees" the two input ready variables
b) The user exit processing is not triggered in the planning function and it's taking the already calculated values
Let me know if you require further information.
Best regards,
George