Active Form Used Range 1000 columns wide.

[GPC]

Hi All,

I'm using TM1 Server Build Number: 10.2.20200.55, Excel 2010 Version 14.0.7015.100.

If I slice a view with a handful of column dimensions to an Active Form, the Excel Used Range is 1000 columns wide. I can remove the additional columns, but after rebuilding the sheet it comes back to being 1000 columns again. This results in a 20 Mb workbook rather than a 2 Mb workbook. I have worked around it by using VBA to remove the excess fat prior to saving but I'm wondering if others have this issue with 10.2.2 or indeed any other versions of TM1.

thanks,

Gregory

[lotsaram]

Yes. This is not a 10.2.2 active form issue but a generic one.
I for one always delete all surplus rows and columns before publishing an active form.