When i uncheck the filter option it populates the data. Running the same sheet in the online excel program the action works correctly. (double click on sum data, new sheet is generated and data is populated)
The data is correct the issue is the new spreadsheet on the desktop version does not fill the content until you some action. Bug in Excel? setting that is missing?