Pivot Tables are Automatically refreshing
 

Can anyone tell me where I might be able to find an answer about automatic
pivot table refereshes in Excel 2002? I have a spreadsheet that is
automatically updating pivot tables which are pulling data from 2 SQL Queries
from an SQL Server Database. I haven't been able to recreate this feature in
other spreadhseets and am being told that the spredsheet isn't supposed to be
doing this, however, it ABSOLUTELY IS UPDATING WHEN THE QUERY IN THE DATA
TABLES REFRESHES AUTOMATICALLY.

Thank you,
--
TMB