Forum Discussion

Robert_DRA's avatar
Robert_DRA
New Contributor
5 months ago

Cube View Connection – Excel Formula Not Being Retained

Hi

I linked several cube views into Excel with the settings below (Version 8.4.0). I then created some basic formulae within the cube views. E.g. = C25. The Excel formula is retained by the first cube view but in the other cube views it is moving up 4 rows on each refresh. The Cube View Connection options are the same in each one. I have tried selecting/deselecting the insert/delete rows & columns and including/excluding the header. The cube views all have some rows with a specific account and at least 1 row that uses “.Base”. Has anyone come across this before?

Thanks.

Robert

Excel Add In
    • Robert_DRA's avatar
      Robert_DRA
      New Contributor
      2 months ago

      Hi

      I haven't had any proposed solutions yet. It isn't critical just a bit annoying so I haven't followed up much.

      • halbrooks100's avatar
        halbrooks100
        New Contributor III
        2 months ago

        I have a ticket open with OneStream, I will post here if I find out anything good