Skip to Content

Dynamic cell styles in analysis for office( 2.2.2)

Feb 09, 2017 at 07:25 PM


avatar image
Former Member

HI Experts,

searched blogs before posting

I am just struggling to find a way for dynamic cell sizing if anyone could give me hint that would really helpful

here is my scenario

i have a crosstab like this i have different cell styles for actuals ,plan,forcast that was the business requirement. if you can see top i have a hierarchy (NOT Assigned) when user clicks on "+" it will expanded to different WBS element

after expanding please see below screenshot

thee are no more cell styles . want to have same cell styles what i have applied for actual s,plan,forecast even though user expands that + button .hope you guys are understandable if not please let me know will explain in detail

settings in cross tab

lt4x7.png (34.4 kB)
dpno3.png (13.6 kB)
e60gu.png (14.8 kB)
2tle0.png (6.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Feb 09, 2017 at 08:33 PM


I am on 2.4; not sure it works the same in 2.2

First you need to format your area, using the Format Cells ribbon

Then the cell styles should stay with the cross tab.

1varunao.jpg (39.3 kB)
10 |10000 characters needed characters left characters exceeded