Search found 4 matches

by dwise
Tue Feb 21, 2017 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form creating hundred of blank columns?
Replies: 12
Views: 8061

Re: Active Form creating hundred of blank columns?

Hi Steve

No PMR raised as far as I know.

Cheers
David
by dwise
Thu Oct 08, 2015 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form creating hundred of blank columns?
Replies: 12
Views: 8061

Re: Active Form creating hundred of blank columns?

I had a similar issue a while back with some reports and deleting the unused columns, saving and re-opening the workbook did not seem to resolve. What I recall doing was adding something in column XFC then isnerting a column before XFC to push contents to last column, saving, closing, reopening the...
by dwise
Thu Oct 08, 2015 1:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form creating hundred of blank columns?
Replies: 12
Views: 8061

Re: Active Form creating hundred of blank columns?

Hi Tomok Thanks for the reply. I had already checked the TM1RPTFMTRNG range and it is correct. As an example on one active form the TM1RPTFMTRNG is from $C$2:$Q$9 but the last active cell (Ctrl+End) changes to column ALL on rebuilding the active form, while the TM1RPTFMTRNG range doesn't change. I h...
by dwise
Wed Oct 07, 2015 10:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form creating hundred of blank columns?
Replies: 12
Views: 8061

Active Form creating hundred of blank columns?

Hi First time poster so please forgive me if I break any forum rules/etiquette. We are using TM1 10.2.2 on Excel 2010 and I have noticed an issue with active forms I've created recently: on rebuild the active form seems to generate blank columns up to column ALL. When I say blank I mean that Excel t...