TM1 Forum

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.

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.