TM1 Forum

We are using Planning Analytics for Excel version 2.0
This morning when I opened a file I that has connection to TM1, i got #VALUE! in the data cell containing the DBRW formula. I traced it back to the the cell which is pulling a pulling a value (ie, member selection) from TM1. The value in that cell is "RECALC_0_2". When I double click in the cell, the set editor opens and i can see the member selection in the Current Set.

Why am i getting the RECALC value?

Screen shots attached.

Note: When I open the same file in Perspectives, there is no issue. Also, other users are not experiencing this issue.

Did you connect to your TM1 environment via PAX or only open the file? If you connected, what happens when you click the Refresh Sheet or Refresh Book option in the PAX toolbar and not just hitting F9 on your keyboard like you would in Perspectives.

I noticed that on custom and dynamic reports, excel circular references from any open workbook will break refreshes.

I tried opening Excel and connecting to PAx before opening the file. I always use the Refresh Sheet/book option from the IBM Planning Analytics ribbon, not the F9 key. Still getting the same error.

Instead of F9 try [Ctrl]+[Shift]+[Alt]+[F9]

a1m80t wrote: ↑Thu Nov 07, 2019 3:38 pm I noticed that on custom and dynamic reports, excel circular references from any open workbook will break refreshes.

This jogged my memory. A few months ago, I had a user with the same issue Peter describes and it was circular reference. A circular reference interrupts the calc operation in excel which I believe is why the cells stay in recalc state. Below is a link with details on how to find circular references.


https://support.office.com/en-us/articl ... 49cd50d123