Log In
Register
Home
Stop Refresh of column widths when refreshing cube values
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
Offline1
March 16, 2023 - 9:47 pm
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: 4449
Member Since:
July 16, 2010
July 16, 2010
Offline2
March 20, 2023 - 10:48 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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Alexandra Radu
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6219
Posts: 27276
Member Stats:
Guest Posters: 49
Members: 31903
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —