Data model has stopped refreshing in latest Excel build - 16.0.14430.20234

%3CLINGO-SUB%20id%3D%22lingo-sub-2819491%22%20slang%3D%22en-US%22%3EData%20model%20has%20stopped%20refreshing%20in%20latest%20Excel%20build%20-%2016.0.14430.20234%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819491%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20long%20standing%20excel%20workbook%20that%20has%20just%20stopped%20refreshing%20correctly%20after%20the%20update%20to%20v16.0.14430.20234%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20taken%20Excel%20back%20to%20v16.0.14326.2040%2C%20and%20the%20spreadsheet%20works%20correctly%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20an%20external%20query%20(to%20a%20SQL%20server)%20returning%20data%20to%20a%20worksheet.%20This%20data%20table%20is%20a%20part%20of%20the%20data%20model%2C%20and%20from%20the%20data%20model%20we%20create%20a%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20the%20most%20recent%20office%20update%2C%20the%20external%20query%20returns%20current%20data%20to%20the%20spreadsheet%2C%20but%20the%20data%20model%20does%20not%20pick%20this%20data%20up%20(until%20you%20actually%20open%20the%20data%20model%20itself%2C%20and%20then%20everything%20catches%20up).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20I%20can%20resolve%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERichard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2819491%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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

1 Reply
That's right, I face the same issue recently