I saved a query as a worbook and also added a new worksheet in the workbook which has excel formula's calculating data from query sheet.
Now the issue Iam facing is the workbook is not refreshing with the current values I enter in the variable screen. Instead the workbook is showing results for the intial entries I used while saving the workbook.
In workbook settings I have the following clicked; Refresh workbook on open, process variables on refresh. Am I missing anything, Please advise.
FYI - we are in front end patch 10.