Pivot table report filter does not display blanks as a selection option

Hello,  

I've created an Excel pivot table by automation from access.  When I open the created workbook, all the data apppears to be there, including any that contain blanks.  When I apply a filter to those fields, blanks appear as a selection option.  However, If I use a field that contains some blank cells, and set it as a report filter on the pivot table, blanks do not appear as an option in the report filter
Juan VelasquezAsked:
Who is Participating?
 
Katie PierceCommented:
That's interesting.  I ran a Pivot Table myself to test it out, and I found "(blank)" at the bottom of the drop down list for the filter.

Can you upload a sample so I can see the problem?
0
 
Katie PierceCommented:
Hi chtullu135, have you had any success on this issue?
0
 
Juan VelasquezAuthor Commented:
Yes I did.  It started to work for me and I posted my reply but for some reason I am having trouble posting replies from work.
0
 
Juan VelasquezAuthor Commented:
I tried shutting down and restarting my computer.  It then started to work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.