Forum Replies Created
-
Posts
-
I did make some progress on this. I had other measures showing as errors (I hadn’t bothered with them until I could figure out why the CUBEVALUE formulas weren’t working). They were unrelated to the measures used in the CUBEVALUE formulas, but nevertheless once I fixed them the strange behavior went away. (Fingers crossed that it stays that way!). I don’t see why it would work for a while and then stop working, but I’m thinking it must be something to do with calculation dependencies somehow(?).
Hopefully this helps anybody else that runs into the same problem.
I’m fairly new to this, but from what I’d read that’s actually how I would have expected it to behave.
When you mark it as a Date Table, I think you’re kind of defining the range of valid dates.
Update: So of course I go back to work on it after posting this and find it’s fixed itself! Which makes me think it’s some kind of memory/calculation glitch. Although I have 8GB of memory and I am running the 64-bit version of Excel.
Odd, though, that it’s only when I add in a 7th slicer that it manifests itself…
