Table names in Excel cube views

OSAdmin
Valued Contributor
Originally posted by Jeff Boryc

I have cube views in an Excel document. When I am trying to create formulas to certain sections of the spreadsheet, it references table names. This makes it extremely cumbersome to build anything out because each cell needs to be setup individually. Turning off Excel references to tables does not fix the issue. I can delete the name references, but that makes the cube view un-refreshable. This pretty much makes cube views in Excel a non usable function. How do I fix this???

0 REPLIES 0