Post your code. If two fo the worksheets are updated then it weem tha
the focus may be changing. I think you may be using Active Shee
instead of specifying the sheet by names like Sheets("Sheet1").

What happens if you change the the two query table that get updated t
two different query table doess the same thing happen?

Do you have any Event Macro that may be causing the focus to change t
a different sheet? Event macros could be causing some unexpecte
results

--
joe
-----------------------------------------------------------------------
joel's Profile: 22
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=16406

[url="http://www.thecodecage.com"]Microsoft Office Help[/url