G
Guest
Hi, anyone please help....
I have an existing excel file with pivot table referencing to an SQL server
database.
Since the excel file was created by another person no longer in the office,
I do not know exactly what specific sql statement or statements it is linked
to.
Now, the current data contains only items from until a last year. I want to
modify that to include data for the current year, i already modified all sql
statements in the queries folder containing the limited year range, but it
doesnt give any effects in the excel file.
Is there a way to know which sql statement is linked or used as a data
source of an existing excel pivot table? If then, how to I "refresh" the data
in the current excel file to show the modifications i made in the sql
statement? Is the "enable automatic refresh" enough?
Thanks very much for any help...
I have an existing excel file with pivot table referencing to an SQL server
database.
Since the excel file was created by another person no longer in the office,
I do not know exactly what specific sql statement or statements it is linked
to.
Now, the current data contains only items from until a last year. I want to
modify that to include data for the current year, i already modified all sql
statements in the queries folder containing the limited year range, but it
doesnt give any effects in the excel file.
Is there a way to know which sql statement is linked or used as a data
source of an existing excel pivot table? If then, how to I "refresh" the data
in the current excel file to show the modifications i made in the sql
statement? Is the "enable automatic refresh" enough?
Thanks very much for any help...