on 07-03-2017 2:47 PM
Hello Team,
We are re-using the standard IBP EPM Planning view Templates for our development. As per the below image, if we can divide the planning view template in to 4 quadrants, we don't want to waste much of the excel space for Q1 and Q3.
I mean to say, we have very few planning levels in any of our to-be planning view templates and very high numbered time buckets in Q4
Question:
i) How can i minimize the Columns widths in Q1 (Column A to J) without impacting the EPM formatting? Especially the Text-boxes, Lists & Filters formatting in Q1 ?
When i tried to minimize the column width and save the template forcibly, Upon refresh the planning view is auto adjusting to its original widths. Is there any way to do the column width formatting
Please suggest
Thanks
VenKat
Hi Venkat,
Disable Auto Fit Column With in Sheet Options and use vba, similar to this:
Sub After_Refresh()
Columns("A:A").ColumnWidth = 18.86
Columns("B:B").ColumnWidth = 15
End Sub
/Cecilia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.