How do I keep slicers and column sizes in my pivot from changing
how keep slicers , column sizes in pivot changing?
hi alexmartini,
slicer size, please right click slicer->size , properties, format slicer window, can format slicer want. please see highlighted in red line.
column size, right click pivot table->select pivot table options. in pivot table options dialogue box, click “layout , format tab”, , uncheck “the box autofit column widths on update”. please see highlighted in yellow shown in screenshot below. after that, column width doesn’t change each time pivot refreshed, need define how wide column urls should be. go pivot , select column long urls. right-click, , enter value column width.
if have issue, please feel free ask.
best regards,
angelia
slicer size, please right click slicer->size , properties, format slicer window, can format slicer want. please see highlighted in red line.
column size, right click pivot table->select pivot table options. in pivot table options dialogue box, click “layout , format tab”, , uncheck “the box autofit column widths on update”. please see highlighted in yellow shown in screenshot below. after that, column width doesn’t change each time pivot refreshed, need define how wide column urls should be. go pivot , select column long urls. right-click, , enter value column width.
if have issue, please feel free ask.
best regards,
angelia
msdn community support
please remember click "mark answer" responses resolved issue, , click "unmark answer" if not. can beneficial other community members reading thread. if have compliments or complaints msdn support, feel free contact msdnfsf@microsoft.com.
SQL Server > Power Pivot
Comments
Post a Comment