Good Morning - 

I have a very granular power pivot table of about 2,000 rows and 4 separate data sets of information covering 4 calendar years.  In one specific set, I have 1,900 rows of data that I'm trying to pull information into a regular excel sheet for reporting purposes.

I have approximate 400 rows that weren't included in my data set, but found through a MATCH.  Some of the rowss have the customer numbers I'm looking for, however, more than half have a "blank" cell, but if I hover over the cell, I can see the information for the customer number.

How do I display this blank cell with the information I see when I hover over the cell?

Thanks,  O24

O24, is this still an issue?

Thanks!

Ed - Yes this is still an issue.  I've mitigated to remove some of the items to get me the number I need, but it would be better if all data was shown. 

Thanks for any advice.

I don't know this one. Does anybody have a suggestion for O24 about how to see all the data?

Thanks!

Does anyone have a suggestion of how to do this?

Thanks!

Hi O24,

Are you able to provide some screenshots to help explain the problem? If possible, are you also able to provide a workbook with non-sensitive data that exhibits the same problem to help members of the forum understand the problem better and form their solutions?