I'm building a report in Excel where I have 4 sections.
#1. Static Section
#2. Active Form Section
#3. Static Section
#4. Active Form Section
Everything works perfectly except when I rebuild the sheet by pressing Alt+F9, it adds a bunch of rows between Active Form Section (#2) and Static Section (#3). Has anyone encountered this problem? If so, any ideas on how to solve this?
Thanks for your time.
TM1 9.4 Active Form Report
-
Kenneth Limanseto
- Posts: 1
- Joined: Fri May 14, 2010 5:54 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
TM1 9.4 Active Form Report
Last edited by Kenneth Limanseto on Mon May 17, 2010 5:42 am, edited 1 time in total.
-
rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: TM1 9.4 Active Form Report
Are you creating the second form as a Active Form Dependent Section?
By default, forms and sections are named ARPT#, where # is a number that is sequentially
incremented for each form or section in a worksheet. The first form or section in a worksheet
is named ARPT1, the second form or section is named ARPT2, and so on.
By default, forms and sections are named ARPT#, where # is a number that is sequentially
incremented for each form or section in a worksheet. The first form or section in a worksheet
is named ARPT1, the second form or section is named ARPT2, and so on.
Cheers!
Rizwan Kaif
Rizwan Kaif