But the Data Model is gone, so for anyone needing/wanting to preserve their Data Model, do not use this approach.Ĭheers sure if this helps but putting my experience here for anyone else looking at similar issues. open xlsx with Excel again and respond to prompts that Excel needs to make repairs to the fileįor me I am left with a perfectly working xlsx.
EXCEL 2016 QUERY EDITOR ERRORS VIEWING ZIP
open the xlsx with favorite zip tool (i used 7zip) I should preface that I am using Excel 2016. I wanted to do was remove the Data Model as these errors were preventing Power Query from refreshing other external connections.įinally I found a way to get rid of the Data Model completely. In any case, i began getting the same Data Model errors described by the OP.
I had converted my pivots to reference tables, etc that were loaded to sheets by power query. If it works check if there is any add-ins was loaded, try to disable them. Do you try to open in safe mode As New Query is a part of Excel, you can run it in safe mode please try it. The error can be cause by different factors related to installed program or installed hardware. In my particular situation I was no longer using the Data Model. Exception code: 0xc0000005, this is a very broad error. Not sure if this helps but putting my experience here for anyone else looking at similar issues. Update: also happens when only 1 Excel file is open analysis and other SQL Server services are stopped, etc. Also on a colleagues computer this problem occurs (so it is in the workbook itself).Īn old version from 2 weeks ago, still works. On the second one I found several tips (repair Office, reboot, etc), but nothing helps. The first message I can't find on the internet.
PowerPivot is unable to load the Data Model An issue with the Data Model is preventing Microsoft Excel from opening this workbook. The source are SQL Server views and a stored procedure. I have an Excel workbook with sheets with PivotTables using PowerPivot to fill them.
0 kommentar(er)
