Oct 06 2021 01:08 PM
Good afternoon,
We have a long standing excel workbook that has just stopped refreshing correctly after the update to v16.0.14430.20234
We have taken Excel back to v16.0.14326.2040, and the spreadsheet works correctly again.
We have an external query (to a SQL server) returning data to a worksheet. This data table is a part of the data model, and from the data model we create a pivot table.
With the most recent office update, the external query returns current data to the spreadsheet, but the data model does not pick this data up (until you actually open the data model itself, and then everything catches up).
Does anyone know how I can resolve this issue?
Thank you
Richard
Oct 27 2021 11:46 PM