Hi,

I have 2 sheets in Excel... in the second sheet... I pass
a value.. the first sheet applies a formula to the value
that was passed in and stores it in a cell...

My problem occurs when I try to query sheet 1 in DTS after
the formula has been applied.. it seems to pick up the old
values.. I opened the Excel file and looked at the
values...The values in sheet 1 that i saw..do not match
the query to the same file..Sheet 1...

Anyone know how to solve this issue..


I have also tried the : "Close connection on completion" in the workflow.

No solution yet... does anyone have one?

Thanks a bunch,

niv