Forum

Stop Refresh of col...
 
Notifications
Clear all

Stop Refresh of column widths when refreshing cube values

2 Posts
2 Users
0 Reactions
166 Views
(@alib40)
Posts: 113
Estimable Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: