Question description:
This user has given permission to use the problem statement for this
blog.
Good Morning
I have data with multiple pivot tables. I have a slicer with date ranges, example 07-29-18 to 08-11-18, that brings the data together with this date range. When I choose this date range the data shows blank. When I choose Blank on my slicer the data shows up. I have removed the data and re-entered it. File is very large and has been working up to this date. If I go to the next date range I get the data
Solved by M. L. in 23 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/08/2018 - 03:27
Hi
User
16/08/2018 - 03:28
Hi
Excelchat Expert
16/08/2018 - 03:28
So, it's not possible to share the file?
Excelchat Expert
16/08/2018 - 03:28
because of the volume
User
16/08/2018 - 03:29
there are so many link files that I'm unable to. It resides in our network
Excelchat Expert
16/08/2018 - 03:29
okay
Excelchat Expert
16/08/2018 - 03:29
So, the problem is that the slicer is not pulling up data for one of the date ranges?
User
16/08/2018 - 03:29
I would love to as this is driving me crazy
User
16/08/2018 - 03:29
correct
User
16/08/2018 - 03:30
I can give you screen shots
Excelchat Expert
16/08/2018 - 03:30
Did you try refreshing the pivot table?
User
16/08/2018 - 03:30
many times and reentered the data
Excelchat Expert
16/08/2018 - 03:30
you have also checked the source data of the pivot table?
User
16/08/2018 - 03:30
also. Did a repair to see if that would fix, it did not
User
16/08/2018 - 03:31
yes i have
Excelchat Expert
16/08/2018 - 03:31
In the source data, the values are present for this date range?
Excelchat Expert
16/08/2018 - 03:31
okay
Excelchat Expert
16/08/2018 - 03:31
Send me the screenshots
User
16/08/2018 - 03:31
yes
User
16/08/2018 - 03:31
i will right away
Excelchat Expert
16/08/2018 - 03:32
And for others date ranges, the pivot table changes?
User
16/08/2018 - 03:33
i did create a new pivot table and connected it
User
16/08/2018 - 03:34
[Uploaded an Excel file]
User
16/08/2018 - 03:34
I do use PowerPivot also
Excelchat Expert
16/08/2018 - 03:35
okay
Excelchat Expert
16/08/2018 - 03:36
I am not able to gauge anything from the screenshot
User
16/08/2018 - 03:36
I figured that as you would need to see the data
[Uploaded an Excel file]
Excelchat Expert
16/08/2018 - 03:36
Did you try re-inserting the slicer
User
16/08/2018 - 03:37
Yes but when I do it won't let me connect to any of the pivot tables. That is greyed out
Excelchat Expert
16/08/2018 - 03:38
okay
User
16/08/2018 - 03:39
When I put data in for the next period it works. It's just this date range
Excelchat Expert
16/08/2018 - 03:40
I am not able to figure out why is this happening specifically for a value
Excelchat Expert
16/08/2018 - 03:40
For slicers, to be connected to different pivot tables, those pivot tables should be created from same data source
User
16/08/2018 - 03:40
me neither and that's why I reached out. I've been working on this for 2 days now
User
16/08/2018 - 03:41
with powerpivot you can use mulitple data sources
Excelchat Expert
16/08/2018 - 03:42
Are other filters also applied at the same time?
User
16/08/2018 - 03:42
I can't see any filters on in any of the tables
User
16/08/2018 - 03:42
applied
Excelchat Expert
16/08/2018 - 03:42
okay
Excelchat Expert
16/08/2018 - 03:44
Apart from these, I can't see any other reasons why the slicer won't be working
User
16/08/2018 - 03:44
I know and that's why i reached out
Excelchat Expert
16/08/2018 - 03:45
Mostly, this issue would be because of the source data only
User
16/08/2018 - 03:45
that's what i thought so too
User
16/08/2018 - 03:46
thanks for your help
User
16/08/2018 - 03:46
can you remote into my machine?
User
16/08/2018 - 03:46
and we can look at it
Excelchat Expert
16/08/2018 - 03:46
I am sorry that I cannot be of much help
Excelchat Expert
16/08/2018 - 03:47
There's no option to remote
User
16/08/2018 - 03:47
Why does the Report connections be greye out
User
16/08/2018 - 03:47
ok
User
16/08/2018 - 03:49
I think i have may of found the problem in teh pivot table fields
User
16/08/2018 - 03:49
In the pivot table that i created it is mssing a couple of tables
Excelchat Expert
16/08/2018 - 03:50
okay...
User
16/08/2018 - 03:50
thanks again for your help. Have a great day
Excelchat Expert
16/08/2018 - 03:50
you are welcome
Excelchat Expert
16/08/2018 - 03:50
you too have a great day
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.