Ted Murphy
New member
Excel 2010 ... Connection Changed from "PowerPivot Data" to "ThisWorkbookDataModel"
Earlier this week I had cause to Download Excel 2010 from the MSDN Site and re-install it.
Suddenly the following Function call ="Fiscal Year: "&CUBERANKEDMEMBER("PowerPivot Data",Slicer_FiscalYear4,1) started returning a #NAME error
Once I changed to connection to "ThisWorkbookDataModel" e.g ="Fiscal Year: " &CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer_FiscalYear4,1)
it returns the following:
Apart from having to edit a ton of individual Cell values ... my concern lies with what will happen when I distribute the Workbook to my client ... who will not have updated his copy of Excel 2010.
Anybody know when this change came about?
What is the best approach to take?
Thanks,
Ted
Earlier this week I had cause to Download Excel 2010 from the MSDN Site and re-install it.
Suddenly the following Function call ="Fiscal Year: "&CUBERANKEDMEMBER("PowerPivot Data",Slicer_FiscalYear4,1) started returning a #NAME error
Once I changed to connection to "ThisWorkbookDataModel" e.g ="Fiscal Year: " &CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer_FiscalYear4,1)
it returns the following:
Fiscal Year: 2016 |
Apart from having to edit a ton of individual Cell values ... my concern lies with what will happen when I distribute the Workbook to my client ... who will not have updated his copy of Excel 2010.
Anybody know when this change came about?
What is the best approach to take?
Thanks,
Ted