Is there no way to connect an excel spreadsheet to SD Plus database and use pivot table to create reports within Excel.

I am finding it very limiting and time consuming to generate reports every single time and adjust them manually when exported wheres in Excel pivot table, I can just select the property and then value to get the data in real time.

Hopefully someone will know a better way to generate reports from SD Plus and can assist me.