Excel Pivot Table has stopped interacting

%3CLINGO-SUB%20id%3D%22lingo-sub-2976324%22%20slang%3D%22en-US%22%3EExcel%20Pivot%20Table%20has%20stopped%20interacting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2976324%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pivot%20table%20connected%20toa%20data%20model%20which%20was%20working%20fine%20for%20a%20year%20or%20more%20but%20recently%20it%20has%20stopped%20interacting.%20When%20I%20press%20refresh%2C%20the%20data%20gets%20updated%20(I%20can%20see%20new%20transactions%20in%20the%20data%20model)%20but%20the%20pivot%20table%20does%20not%20change.%20Also%2C%20it%20does%20not%20respond%20to%20slicer%20or%20filter%20selections.%20No%20error%20message%20or%20warning%20appears.%20It%20has%20stopped%20working%20on%20two%20different%20machines%20using%20Office%20365%20(verson%202110)%20but%20it%20works%20ok%20on%20an%20older%20machine%20with%20Excel%202016.%3C%2FP%3E%3CP%3EI've%20never%20had%20this%20issue%20with%20pivot%20table%20before.%3C%2FP%3E%3CP%3EAnyone%20encounter%20and%20solve%20this%20problem%20before%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3EOliver%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2976324%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2976534%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20has%20stopped%20interacting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2976534%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20to%20rebuild%20the%20pivot%20table.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2977699%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20has%20stopped%20interacting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2977699%22%20slang%3D%22en-US%22%3EThis%20exact%20same%20issue%20has%20happened%20to%20me.%20Multiple%20files%2C%20all%20experiencing%20the%20same%20thing.%20Horribly%20inconvenient.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20very%20temporary%20workaround%20is%20to%20upload%20to%20OneDrive%2C%20manipulate%20the%20filter%2Fpivot%20tables%20online%20on%20OneDrive%2C%20and%20then%20export%20a%20copy.%3CBR%20%2F%3E%3CBR%20%2F%3ERebuilding%20the%20data%20model%2Ftables%20is%20something%20that%20would%20be%20very%20time%20consuming%20so%20I%20am%20hoping%20to%20avoid%20at%20this%20point.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2977812%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%20has%20stopped%20interacting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2977812%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20suggestion%20-%20rebuild%20seems%20to%20have%20worked%20but%20it%20isn't%20a%20feasible%20solution%20and%20presumably%20it%20could%20happen%20again.%20I%20need%20to%20understand%20what%20has%20happened%20so%20i%20can%20prevent%20it%20happening%20again.%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a pivot table connected toa data model which was working fine for a year or more but recently it has stopped interacting. When I press refresh, the data gets updated (I can see new transactions in the data model) but the pivot table does not change. Also, it does not respond to slicer or filter selections. No error message or warning appears. It has stopped working on two different machines using Office 365 (verson 2110) but it works ok on an older machine with Excel 2016.

I've never had this issue with pivot table before.

Anyone encounter and solve this problem before?

Thanks in advance.

Oliver

5 Replies
I would suggest to rebuild the pivot table.
This exact same issue has happened to me. Multiple files, all experiencing the same thing. Horribly inconvenient.

A very temporary workaround is to upload to OneDrive, manipulate the filter/pivot tables online on OneDrive, and then export a copy.

Rebuilding the data model/tables is something that would be very time consuming so I am hoping to avoid at this point.

Thanks for the suggestion - rebuild seems to have worked but it isn't a feasible solution and presumably it could happen again. I need to understand what has happened so i can prevent it happening again.
Strangely, I think OneDrive may be related to the problem. I set up the spreadsheet on the network for a user and it has been working fine for over a year. However, over the last month or so I notice that she has sometimes ended up saving it to OneDrive and the file she re-opens may be from the network or OneDrive. I'm not sure if that is relevant to the problem or not.
When I looked at the data model, I could see that the data had updated successfully (which I initally had presumed was the problem). Did you find the same thing?