Excel file in OneDrive- Forms Data not refreshing in pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-1452238%22%20slang%3D%22en-US%22%3EExcel%20file%20in%20OneDrive-%20Forms%20Data%20not%20refreshing%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1452238%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20new%20Form%20from%20Excel%20using%20MS%20Forms.%26nbsp%3B%20%26nbsp%3BWhen%20I%20open%20the%20excel%20file%20in%20OneDrive%20that%20holds%20the%20data%2C%20I%20also%20have%20a%20page%20with%20pivot%20table%20to%20analyze%20the%20data.%3C%2FP%3E%3CP%3EI%20can't%20seem%20to%20get%20the%20pivot%20table%20to%20auto-update%20as%20the%20new%20entries%20are%20received%2C%20although%20the%20data%20source%20page%20that%20collects%20the%20forms%20data%20is%20updating%20fine.%3C%2FP%3E%3CP%3EThe%20only%20way%20to%20update%20pivot%20table%20is%20to%20open%20it%20in%20desktop%20version%2C%20and%20then%20change%20the%20data%20source%20properties%20to%20show%20the%20new%20rows%20of%20data.%26nbsp%3B%20Then%20save%20back%20to%20online%20version.%3C%2FP%3E%3CP%3EIs%20there%20another%20way%20around%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1452238%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20pivot%20table%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1475052%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20in%20OneDrive-%20Forms%20Data%20not%20refreshing%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1475052%22%20slang%3D%22en-US%22%3E%3CP%3EI%20too%20am%20having%20this%20problem.%20Even%20though%20I%20did%20add%20auto-refresh%20to%20my%20pivot%20table%2C%20it%20does%20not.%26nbsp%3B%20You%20have%20to%20refresh%20the%20table%20every%20time%2C%20which%20is%20not%20optimal.%20I%20hope%20you%20get%20an%20answer%20soon!%3C%2FP%3E%3CP%3ESo%20far%20I%20have%20only%20seen%20to%20allow%20macros%20and%20add%20vba.%20That%20isn't%20an%20option%20for%20us.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnless%20you%20will%20always%20be%20opening%20with%20the%20desktop%20app.%20Then%20you%20can%20just%20choose%20the%20options%20in%20the%20pivot%20table%20to%20auto%20refresh%20on%20opening%2C%20but%20that%20does%20not%20auto%20refresh%20when%20data%20updates%20if%20already%20open%2C%20nor%20does%20it%20auto%20update%20in%20the%20browser%20excel.%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 table to auto-update as the new entries are received, although the data source page that collects the forms data is updating fine.

The only way to update pivot table is to open it in desktop version, and then change the data source properties to show the new rows of data.  Then save back to online version.

Is there another way around this?

1 Reply
Highlighted

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.