Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
91
Views
Topic starter
Hi
I have a powerpivot report using cubevalues. One of the columns has an up / down arrow using custom formatting rather than showing the value and therefore only needs to be 3 wide.
When I refresh the data the column reverts to a much bigger width.
How can I stop it from doing this?
Posted : 17/03/2023 7:47 am
Hi Allison,
The CUBE functions are unlikely to be the cause. It's more likely that you have a PivotTable that's in the same column as your up/down arrows and the PivotTable is resizing the column on refresh.
You can turn this off in the PivotTable Options (right click) > uncheck 'autofit column widths on update'.
Mynda
Posted : 20/03/2023 8:48 pm
