I looked at the submissions in the group, and the VB script solution
didn't work for me, hence this question.

Have a workbook in which the data is obtained from a database. This is
stored in one worksheet called "All Data". Another worksheet has a
pivot table which depends on the "All Data" worksheet. My problem. The
data in the "All Data" refreshes automatically each time I open the
workbook. However, for the refresh to work on the pivot table I have to
manually click the "Refresh all data" button. Is there any way to get
around that??? Please help.

Thanks.

Aastha