auto update my pivot table

[rodchar]

hey all,

is there a way to update my excel file, automatically, which contains a
pivot table attached to a sql server datasource? Without having to manually
open the file and update the datasource.

thanks,
rodchar