This sounds an incredibly useful capability to have. May I ask which data connector did you used to pull data, and how did you made it available in that format from the app side?
[0] https://support.office.com/en-us/article/Get-external-data-f...
Since it was a system for internal use, that was deemed acceptable.
So that gives the user the ability to query for a certain date, or sum for a date range, or to get a breakdown by some meta data. Being able to load multiple reports allows them to do deltas. And switching to a newer version of the report just takes changing the argument of the load function and press F9.
Worth also giving the users sample spreadsheet, or having a way to export the full report with all these formulas in Excel so that they can learn by example.
The only thing to watch for is memory clean up. You need somehow to have a way to unload all reports otherwise your memory blows up over time.