In Odoo 17.4 you have the option to insert a dynamically changing pivot table into a spreadsheet and you could also convert it into a static table following these steps:

1. After you create your report you can insert it into a spreadsheet:

2. By default pivot tables inserted in spreadsheets will be dynamic. So if I create a new sales order the pivot table will be updated:

3. If you would like to convert it into a static table, then you can highlight the table, right click, and then click on "convert to individual formulas":

4. Now, the table won't be updated dynamically: