TM1 Forum

Hi all

I'm not sure if this has come up before, but I've got a strange situation with a slice. I've got some DBRW cell forumulae which update ok, however SOME dependant cells don't seem to want to recalculate (e.g. a Sum formulae).

I've tried using Shift+F9, F9 and Alt+F9 but these dependant formulae don't seem to want to change. The only way I can get them to update is by selecting the cell and hitting F2 then Enter.

This isn't an overly complex workbook, and strangely other sheets work fine, it's just some formulae on this one tab that are playing up.

Has anyone come across this before or know a better way of recalculating the whole workbook?

Thanks in advance.

Stab in the dark, but in the cells for the sum formulae, could they be formatted to text?

Have you tried inserting another column, ensuring the format is general and recreating the sum formula and testing that?

They seems to work as normal after edit/enter. It was only 4 cells that were affected on the sheet. I guess I was hoping to find out the cause to avoid having this happen in future.

I know that I grouped tabs together to do a bulk edit, and maybe this triggered a bug. It's possible this was an excel issue and not a perspectives one.

NPTM1 wrote: ↑Tue Nov 21, 2017 12:38 pm I've got some DBRW cell forumulae which update ok, however SOME dependant cells don't seem to want to recalculate (e.g. a Sum formulae).

What exactly do you mean by "SOME dependant cells"? Do you have nested DBRW formulas. By that I mean the result of one DBRW is used in another DBRW? If that is the case it is a no-no. You will need to change the source DBRW to a DBR.

Is this behavior in TM1Web or Perspectives?

Also, are they ruled cells, excel formulas, or TM1 Consolidations?

NPTM1 wrote: ↑Tue Nov 21, 2017 2:08 pm They seems to work as normal after edit/enter. It was only 4 cells that were affected on the sheet. I guess I was hoping to find out the cause to avoid having this happen in future.

I know that I grouped tabs together to do a bulk edit, and maybe this triggered a bug. It's possible this was an excel issue and not a perspectives one.

If you ever get this again, try Ctrl+ Shift + Alt + F9. (That is, every modifier key.) It not only recalculates but rebuilds the dependency tree as well. From what you're describing it's possible that your multi-sheet edit caused a problem in the tree. It shouldn't in theory, but in practice... y'never know.

This can also happen when you somewhere have a DBRW formula which points to an intersection in the cube that is not part of the VIEW formula that you refer to in the DBRW.

The CTRL+ALT+SHIFT+F9 worked, definitely something I'll keep in mind, many thanks Alan.