I have a Pivot chart that is very sensitive. When mutually exclusive variables are selected in any of the 4 visible drop down filters, it crashes. I understand why it does this, I'm just wondering how to prevent it. When you do this mismatch in a pivot table, the data field just goes blank, but it does not crash and reboot/recover file.
So why does the pivot graph crash. This means my users will have to pre-know what is compatible and what conditions are mutually exclusive, right?
My clients are executive who don't really know any of this...
Any tips/suggestions would be appreaciated~
G.
So why does the pivot graph crash. This means my users will have to pre-know what is compatible and what conditions are mutually exclusive, right?
My clients are executive who don't really know any of this...
Any tips/suggestions would be appreaciated~
G.