Auto Refresh for Pivot Table in Spreadsheet Component

Hi All,

We have a spreadsheet component containing two tabs. One tab has the source data derived from a Table View. The second tab has a Pivot created on the data from First tab. The Pivot Table has "Refresh data when opening the file" checked under Pivot Table Options/Data settings.

The source data tab refreshes as expected if TableView output changes based on the spreadsheet component setting. The Pivot table however does not refresh automatically.

Is this a known issue ( OneStream spreadsheet component vs Excel) or do we need additional configuration to make it work?