Skip to Content
0
Former Member
Dec 28, 2006 at 02:27 AM

Workbook not refreshing with new variable entries

12 Views

Hi Gurus,

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.

Thanks All.