So there’s a monthly report we receive that is only a Pivot table (no tables or data anywhere, just the pivot table).
So we have to go in and double click on grand total to spit the data out onto a new tab. Then we can save the file and throw into our folder that power Query is pulling from.
This all works fine ^
But I’d love to just get the report and toss it in folder and hit refresh. Is there any way to import a file that has only a Pivot table in it? I want the data that feeds that Pivot table.
So we have to go in and double click on grand total to spit the data out onto a new tab. Then we can save the file and throw into our folder that power Query is pulling from.
This all works fine ^
But I’d love to just get the report and toss it in folder and hit refresh. Is there any way to import a file that has only a Pivot table in it? I want the data that feeds that Pivot table.
