SOLVED

Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-2876462%22%20slang%3D%22en-US%22%3EExcel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876462%22%20slang%3D%22en-US%22%3EHi%20there%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20just%20converted%20a%20file%20for%20work%20from%20the%20regular%20desktop%20version%20to%20online%20as%20it%20needs%20to%20be%20shared%20with%20multiple%20people.%20In%20the%20file%2C%20I%20have%20multiple%20pivot%20tables%20that%20we%20are%20consistently%20adding%20data%20to.%20For%20some%20reason%20in%20the%20online%20version%2C%20the%20file%20won%E2%80%99t%20let%20me%20refresh%20the%20pivot%20tables%20at%20all.%20Anyone%20ever%20run%20into%20this%20and%20know%20any%20solutions%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2876462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2876546%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876546%22%20slang%3D%22en-US%22%3EWhy%20don't%20you%20put%20use%20Sharepoint%20Folder%20connector%20to%20connect%20the%20files%20and%20then%20refresh%3F%3CBR%20%2F%3E%3CBR%20%2F%3ESecondly%2C%20Did%20you%20put%20all%20the%20files%20inside%20desktop%20folder%20and%20use%20Power%20query%20to%20connect%20and%20then%20connect%20it%20online%3C%2FLINGO-BODY%3E
New Contributor
Hi there,

I have just converted a file for work from the regular desktop version to online as it needs to be shared with multiple people. In the file, I have multiple pivot tables that we are consistently adding data to. For some reason in the online version, the file won’t let me refresh the pivot tables at all. Anyone ever run into this and know any solutions?
4 Replies
best response confirmed by lmoore_ (New Contributor)
Solution
Why don't you put use Sharepoint Folder connector to connect the files and then refresh?

Secondly, Did you put all the files inside desktop folder and use Power query to connect and then connect it online

@lmoore_ 

If data source is within same file, you don't use Power Query and user has proper permissions, PivotTable shall be refreshable in Excel for web. Both with using data model or not.

 

What exactly happens on Refresh All ?

I have never used SharePoint folder connecter. How do you use that?

And I started by making the pivot tables in the desktop version of Excel. I had two sheets in there that contains a unique list of data and a list of data that we continue to add to. The pivot tables pull from both these source tables of data.
All my source data is within the same file, so I didn’t use power query. When I click refresh all, I get an error message saying ‘this workbook contains external data connections or BI features that are not supported.”