Alison Banks
England
Member
Members
Power Query
Excel for Finance
Power BI
Excel Expert
Excel Customer Service
Financial Modelling
Power Query
Excel for Finance
Power BI
Excel Expert
Excel Customer Service
Financial Modelling
Forum Posts: 115
Member Since:
September 21, 2018
September 21, 2018
Offline
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?
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: David Benady, Dom Brosnahan
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Forum Stats:
Groups: 3
Forums: 24
Topics: 6882
Posts: 30161
Member Stats:
Guest Posters: 49
Members: 33708
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —