Active form doesn't work after save

[wang_chris]

I created a new active form, before saving, everything looks fine.

But when I save and close it, and reopen it, the title in B columndoesn't display correctly as normal.

The fomular of that column is " =TM1RPTROW($B$9,"vBudget_UAT_v1:Account_GL","",'{AR}01'!$B$24:$B$49,"Global_SubCodeName",1) "

What does the {AR}01 mean?

Regards,
Chris

[Alan Kirk]

I created a new active form, before saving, everything looks fine.

But when I save and close it, and reopen it, the title in B columndoesn't display correctly as normal.

The fomular of that column is " =TM1RPTROW($B$9,"vBudget_UAT_v1:Account_GL","",'{AR}01'!$B$24:$B$49,"Global_SubCodeName",1) "

What does the {AR}01 mean?

It means that you should avoid creating active forms with manually selected elements in the rows, though I doubt that that's your problem. More likely you made some changes to the form before you saved it which broke it - rows 19 and 20, for instance, seem to have involved some manual intervention - but it would be hard to make a guess as to what those changes may have been.

When you create an active form you can create the rows in two alternative ways:
(a) By choosing a named subset; or
(b) By having a manually selected subset.

If you go via route (a) the TM1RptRow formula will have arguments that point to the subset name.
If you go via route (b), the ActiveForm creation process will insert a hidden sheet into the workbook, and hard code the elements that you have selected on that sheet. (In this case, a sheet named {AR01}.) The Tm1RptRow function will then refer to the range of cells on that sheet which contain your element selections. You can see the sheet if you right click on the ActiveForm's sheet tab and select "Unhide". There is nothing intrinsically wrong with using this approach if the rows will never, ever change (but if that's the case it's questionably why you need an Active Form at all), but it does mean that if you ever need to change the subset of rows you need to go to that hidden sheet and manually hack the range, whereas if the formula is driven from a named subset all you need to do is update the subset and any and all active forms which are based on it will automatically refresh with the new set of elements.

As I said, I doubt that that's your problem but you may want to check the hard coded range on the hidden sheet to make sure that the elements are all still valid.