Hello Guys.
I built reports and pivot table with slicers in Microsoft Excel, using a Excel table in a different sheet.
Last couple days, the IT team installed SAS Add-in for Office in my computer and I'm trying to replace the pivot tables from Excel with Pivot Tables from SAS datasets.
The problem is: I don't know how to do it.
I clicked on a random pivot table, then I selected Pivot Table Tools --» Options --» Change Data Source --» and after that, I have 2 options. The first one is: Select a table or range (already selected with my Excel table) and the second one is 'use and external data source' but is not ativated or it is disabled.
So, how do I replace my Excel pivot tables with SAS Dataset pivot tables?