2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Dynamic Reference of Slicer in Cubevalue function

Hello everyone,

TLDR - just read "The problem"

I have a tab with lots of Cubevalue formulas and several slicers (slicer_tab1_slicer1, slicer_tab1_slicer2 etc.). Now I want to copy-paste this tab a few times. When I do so, my cubevalue formula still contains the references to the tab1 slicers, instead of the new tab2 slicers.

My idea is to create a small list on top of every tab saying: "References to the slicers in this tab that should be used in the formulas": "slicer_tabx_slicer1", .... So instead of changing all the formulas, I reference this small list in my formula. And when I copy-paste my tab, I just need to read out the correct formula names of my new slicers, change the list "references to the slicers in this tab that should be used in the formulas", and all formulas work perfectly.

The problem: Cubefunction does not seem to read references for slicers when they are stored in a field. So if i have a function =CUBEVALUE(Datamodel, bla, bla, bla, Slicer_tabx_slicer1) it works, but when I write =CUBEVALUE(Datamodel, bla, bla, bla, A3) and A3=Slicer_tabx_slicer1 it doesn't work.

How can I solve this? Thanks in advance!

PS: It's excel 365...

submitted by /u/New-Lingonberry9322
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#CUBEVALUE
#slicers
#Excel 365
#Cubevalue formula
#function
#Excel formulas
#Dynamic Reference
#Datamodel
#slicer_tab1
#formula names
#references
#slicer_tab2
#dynamic list