I have a Sharepoint application that uses a graphical element of a Pivot Table in an Excel Web Access (Web Part). The issue is that I can not 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 report's Web Part.
2- Using the connection settings inside the excel file before uploading the file to Sharepoint, selecting the properties and checking the option "Update data when opening file".
3- Using the same properties as the previous example and checking the option "Refresh every x minutes".
Given all these "solutions", I'm having the following problems for each of them:
1- It is the most viable solution of all, since it shows to the user that the graph is updating, but if you change pages the data is lost, requiring a new update.
In addition, the chart always returns to the initial data of the day it was imported, so the more time passes, the worse it will be to update the chart, as the data mass will increase.
In this solution when I open the graph, it asks a question to update the querys and data received, so far so good, however when accepting it starts to update but does not return any type of " answer "that the same is updating. It simply pops up on the screen when it finishes updating, spitting out the new information. It also has the same problem when leaving the screen and always keeping the initial data of the day the report was created.
3- The solution that does not work, because within excel updates, changes the values, already within the Web Part does not change absolutely nothing, it is as if it did not exist, regardless of how much time passes.
Well, I wanted to ask for help to make this report readable and well-performing for users, I wanted to know if there was any other way to do this or if there was anything I did wrong in the above solutions. Have I tried the correct shapes? Is there any other possibility?