I created the  Report in separate sheets with Pivot Table. The cell/columns formatting are complete e.g. alignment, date and number formats, conditional formatting. The Excel Template has been linked to SIR.

The Pivot Table is set to Preserve cell formatting on update and it has column filter.

Issue is every time the report run its reformatting cells e.g. the numeric columns changes to date,  collapsed button is visible, text alignment and so on.