Excel Power Pivot
Can anyone tell me how we would proceed with a Power Pivot in Excel?
Specifically to access Transfer Reports, that auto populate (update) data from the site.
I'm looking to simplify my company's transfer reporting for data tracking.
At the moment, I format the data into a table, and filter for the appropriate transfer number.
However, my coworkers are not quite as savvy. I would like to pull the data and have one set workbook, where they can utilize slicers. And don't have to constantly export a (.xlsx) of the data.