Forum Discussion
Excel file in OneDrive- Forms Data not refreshing in pivot table
I created a new Form from Excel using MS Forms. When I open the excel file in OneDrive that holds the data, I also have a page with pivot table to analyze the data. I can't seem to get the pivot t...
I too am having this problem. Even though I did add auto-refresh to my pivot table, it does not. You have to refresh the table every time, which is not optimal. I hope you get an answer soon!
So far I have only seen to allow macros and add vba. That isn't an option for us.
Unless you will always be opening with the desktop app. Then you can just choose the options in the pivot table to auto refresh on opening, but that does not auto refresh when data updates if already open, nor does it auto update in the browser excel.
