Hello,

I've been coming across a more frequent problem lately. I create pivot tables with slicers and I end up needing to create a formula to reference the slicer information. Most times, the formula is being used to reference a data set separate from the one used in the pivot and there are no easy unique joins to make within the pivot.

In my research, it would appear that the only way to reference slicer info is through CUBE functions...which are then only applicable for powerpivots. First thing first, is there a way to reference the slicer array without a cube function, sans powerpivot? Say within a sumifs or index/match? If not, is there an easy way to take a regular pivot table and convert it to a power pivot? I usually avoid the step of "add this data to the data model" as I believe it inflates my workbook size when I don't need to take advantage of any power pivot functionality. Anyway, that step is on creation of the pivot...any way to do it after the fact?

Thanks