Excel Pivot Table Format Messed up

T

Tim879

Hi,

Recently (I'm not sure why) the pivot tables I create have no lines on
them (more technically -- all of the lines are white and you can't see
them)? I am not sure what setting I changed or why this has started
happening.

Does anyone know how to change this back to the default settings?

thanks
Tim
 
M

Mike H.

Reselect some other parameter in the pivottable should auto-refresh. I
couldn't find anything else that would affect this.
 
J

Jim Thomlinson

As a guess you selected the auto format option from the pivot table menu and
selected the final option None which removes all formatting. To go back to
the default autoformat select Auto Format from the pivot table menu and then
select Pivot Table Classic (second last choice) to go back to standard lines.
 
Top