Refresh Pivot Table SQL Server

[MatthewOwens]

Hi,

I have an Excel document, that contains a single pivot, populated from a SQL Server view.

Can anyone help me refresh the data in the table from the SQL Server view, without displaying a dialog to the user? Fully automated.

I have tried recording a macro to do it, and calling that, but unforunately when called, the database table dialog still pops up and asks me to chose the SQL Server table driving the pivot table.

Any help would be much appreciated.
Thanks in advance