How Would You Enable Automatic Refresh In Pivot Table Upon Opening Th

1.	How Would You Enable Automatic Refresh In Pivot Table Upon Opening The Workbook Without Using Macros?
Answer» This can be DONE from PIVOT Table Options. Go to "Table Options" --&GT; Data --> Select 'Refresh data when OPENING the file. This can be done from Pivot Table Options. Go to "Table Options" --> Data --> Select 'Refresh data when opening the file.

How Would You Enable Automatic Refresh In Pivot Table Upon Opening The Workbook Without Using Macros?

Answer»

This can be DONE from PIVOT Table Options. Go to "Table Options" --&GT; Data --> Select 'Refresh data when OPENING the file.

This can be done from Pivot Table Options. Go to "Table Options" --> Data --> Select 'Refresh data when opening the file.