I have checked all the options for the auto refreshing in the pivot table options to fire when the file is opened. However it will still not auto refresh. The problem might stem from the data actually coming from a sharepoint site through a data connection. Since that data is getting auto refreshed when the file is opening the pivot tables might not be since they are all refreshing at the same time. Is there a way I can do this auto refreshing without a macro?