Values from data file not updated upon reload

[#1]

Scenario:

I have 6 expressions in a pivot table out of which 3 are inputfields. source for these inputfields are from an excel file. When values are updated in excel file, the same are not reflected upon data reload. Values loaded during first reload continues to display. However, upon trying to reload 3-4 times, new values at pulled during one of the attempts.

Data model sample script is as below:

Main table:

Load

     %Key

     Dim1,

     Dim2,

     Dim3,

     Dim4,

     Exp1,

     Exp2,

     Exp3

from source;

Excelsource:

Load

     %Key,

     Inputfield1,

     Inputfield2,

     Inputfield3

From excelfile;

Table:

Dim1, Dim2, Dim3, Exp1, Exp2, Exp3, Inputfield1,Inputfield2,Inputfield3

A        B         C        1       1        1         10            11              12

Lets say initially values pulled are 10,11,12 for above 3 inputfields. I edit excel file and change values to 5,6,7 instead. When i saved the file and reload my qvw, it continues to show 10,11,12 in my table instead of 5,6,7

When i try to reload 3-4 times , one of the times it clicks and updated values are pulled. I am not able to zero-in on the issue.

Can someone please tell me what can be the cause for this or if i am missing sometime?

[tresesco]

Could you post a sample qvw and excel that shows the issue?