1
I have a Sharepoint application that uses a graphical element of a Pivot Table in an Excel Web Access (Web Part). The point is that I can’t get a very viable way to update the data, I have tried the following ways to update:
1- Using the Date Button, which is an option within the Web Part of the report.
2- Using the connection settings inside the excel file before uploading the file to Sharepoint, selecting the properties and checking "Update data when opening file".
3- Using the same properties as in the previous example and checking "Refresh every x minutes".
In view of all these "solutions", I am having the following problems for each of them:
1- It is the most viable solution of all, given that it shows to the user that the chart is updating, but if you change page the data is lost, requiring a new update.
In addition the graph always goes back to the initial data of the day it was imported, so the more time passes, the worse it will be to update the graph, since the mass of data will increase.
2- In this solution when I open the chart, it asks a question to update the received querys and data, so far so good, but when accepting it starts updating but does not return none type of "answer" it is updating. It simply appears on the screen when it finishes updating, spitting out new information. It also has the same problem when exiting the screen and always keeping the initial data of the day the report was created.
3- The solution that does not work, because inside excel updates, changes the values, already inside the Web Part does not change anything, it is as if it does not exist, regardless of how much time passes.
Well I wanted to ask for help to make this report readable and with good performance for users, I wanted to know if there is any other way to do this or if there is something I did wrong in the above solutions. I tried the right ways? Is there any other possibility?