On 5/7/2021 2:48 PM, Claus Busch wrote:
Hi Duane,

Am Fri, 7 May 2021 14:42:07 -0500 schrieb dpb:

This isn't in the PivotTable but in the data range of the PT when I
tried turning it into a table per a suggestion seen on internet.

I turned it back into a regular range from the table and the banded rows
artifact remained. I guess I could try going back to the table again
and seeing if there's some control there.

I can just revert back to the previously saved version; it's not a
terribly large number of modifications I had made so it's not a
disaster, just inconvenience.

when you right click on as table formatted data = Convert to range you
will get a normal table. But the colors and the borders remain.
You must select the whole range = no fill and no border.

"That's rude!" :) Afraid of that being a non-reversible "feature".

Fortunately, I do have the original, and had, in fact, already reverted
to it and made the edits again.

Thanks for confirming...

--