G
guru
Hi all
I was trying to find some KB on pivot table refresh option.
i have a pivot table that connects to the SQL Db and
updates the data. This one is built using Microsoft Query.
Everything is going fine, except this observation
when i refresh the pivot table from the toolbar button,
the query is executed twice, once in the Microsoft Query
and another in the excel pivot table sheet.
Trying to find out whether there is a way to make this run
once..because, the query execution in the excel pivot
table is taking a very long time.
Thanks in advance
Guru
I was trying to find some KB on pivot table refresh option.
i have a pivot table that connects to the SQL Db and
updates the data. This one is built using Microsoft Query.
Everything is going fine, except this observation
when i refresh the pivot table from the toolbar button,
the query is executed twice, once in the Microsoft Query
and another in the excel pivot table sheet.
Trying to find out whether there is a way to make this run
once..because, the query execution in the excel pivot
table is taking a very long time.
Thanks in advance
Guru