Ever since my company switched to Office 365, the pivot tables in our excel files don't properly update. So, we add data into a sheet and the pivot table tied to it won't properly display the correct count. It may be a Name Manager issue but if I take the same range as the Name and change the pivot table Data Source to the range, it calculates properly but if I put in the Named Range it misses lines for some reason. This has only started a few months ago but since we have files with constantly changing data sizes, it can be frustrating to constantly update the pivot table range when the Named Range should do that on its own.
Is anyone else having this issue and is there any way to fix this?
Bookmarks