TM1 Forum

Hi everyone,

I have got a report with 4 sheets (active forms). We are using Excel 2007 and TM1 9.4 MR1. Is there a way how to rebuilt the whole book using one Action Button? Is there a way how to call an action button from another action button in the report?

I would like to avoid using macro (due to macro security settings) and Rebuild Current Book command in TM1 menu to make it easier for users...
I have tried TM1 help but without any success.

Thanks for your help.

Stanislav

In the Action Button properties if you will use the option of Automatically Recalculate Sheet then you will be able to refresh all the Sheets in your workbook using a single Action Button.

Let me know if that is not something which you want?

rkaif wrote:In the Action Button properties if you will use the option of Automatically Recalculate Sheet then you will be able to refresh all the Sheets in your workbook using a single Action Button.

Let me know if that is not something which you want?

Hi,

Thanks for suggestion. The problem is that recalculating does not work in this case. I suppose this is due to the fact that I am not using SUBNM for some of the title dimensions (e.g. Fiscal Year is linked to another sheet where the value is retrieved from Parameter cube). Therefore each sheet needs to be rebuilt.

Stanislav

Hi all,

I have a similar issue where my Active Form definition includes some standard Excel reference formulas (Lookups) to other worksheets in the same workbook, and they don't update when I open or rebuild the worksheet. Is there a way to do this? Or do I have to keep all those references within the same worksheet only?

Andre

Hi, forgot to add... the workbook calc is set to Manual (and should stay that way), and the aim is to deploy the workbook on TM1 Web, so VB macros are not an option. Thanks.

Andre

All,

Just found out that the refresh and update of external references all work when deploying the workbook to web. But they don't in standard Excel. Strange... and a little inconvenient when in build mode and trying out a few things in Excel. That is, in version 9.4 and Excel 2003.

So, my problem is solved for now.

Cheers.