Refreshall Twice

[romeo16]

HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to refresh it twice to get all pivot tables updated, Is this because I have different source data?

Any help on this will be much appreciated, Thanks

 

[Chrisdontm]

This may be totally off, but, do you have the settings to automatically calculate your tables...?

If not; Go to the Formulas tab, and over to the right, check what calculation options you have it on.

It could be set to not calculate inside tables...

 

[romeo16]

This may be totally off, but, do you have the settings to automatically calculate your tables...?

If not; Go to the Formulas tab, and over to the right, check what calculation options you have it on.

It could be set to not calculate inside tables...

Hi , thanks for your reply yes I did check the calculation is set to automatic and also my workbook doesn't have any table In it. Thanks