Macro to update data

[Cam]

Hello,

I have an Excel file with the following sheets:
Data (import from Access)
Pivot (pivot from Data sheet)
Pivot_Chart (chart from a pivot sheet)

I would like to create a button with a macro that will refresh (update) all
the sheets. Also, is there a way to program it so that once the file is open
it will pop up this button to ask users to click to update data or update it
automatically once the file is open. Any help is appreciated. Thanks

 

[Dave Peterson]

Try recording a macro when you do the updates manually.

Then name that macro: Auto_Open

You can also plop a button from the Forms toolbar on any old sheet and then
assign the Auto_Open macro to the button.