Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Colored cell affects pivot table results

Copper Contributor

In the column of values I used for my pivot table, a cell that was filled with a color, was not counted in my total. There were other cells filled with other colors that were counted; once I removed that one color, it was included in the count. Why did that happen? How do I avoid that error while keeping my colored cells? There was no conditional formating in the column.

1 Reply

@Milspse28 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?