How to resolve error "Something went wrong. If the problem continues, please restart excel’ " when updating Power Query|Power Query|Excel Forum|My Online Training Hub

Hi Phil,

I was attempting to bring in one workbook consists of 25 worksheets (same structure),  after that I did a append as new query,  then close and load to,  then encounter unexpected error,   I copy out the copy details which is similar to the link that I attached

Previously the same process done in Excel 2016 got no issue,  lately change my laptop and loaded with Excel 2019 (not sure whether this is the cause)

btw,  remove the cache and re-run the query and still encounter the same error

Hi Phil

yes I am using on premises excel 2019,  I got 24 worksheets and they are all formatted as tables,  when I bring into a blank workbook using edit directly in power query editor,  then straight away append as new,  all error in editor at all managed to append all the 24 tables together,  it was when I close and load to,  it prompted me the generic error of unexpected error,  and when i click close,   in the worksheet query,  all the 24 queries and 1 appended query are not in connection only mode,   of course if I one-by-one right click load to,  it works

just puzzle what is wrong with it

the datasets I got to mask further before sending to you,   I even create the workbook from scratch and same error

I am using 64 bit,  is there a different

thank you for your response phil

Hi Phil

On-Premise means local installed,   ok,  basically there are 24 worksheets (same structure) in one workbook (same workbook),  what I wanted to do is import all these two worksheet into PQ as 24 queries,  then Append all of them as one,  very simple.  whether I import in and straight away close and load to,  or Append all of them into one single query and close and load to,  the unexpected error still appear

just try Close and load to,   expect all the 24 queries to load to excel but I still receive Unexpected Error

Phil,  thanks for your time,  will explore other alternative, just puzzle the same source file I did the same in Excel 2016 got no problem at all

I will update you once there is findings

Thank you Sir

Hi Mynda, Phil,

Thanks for all the advises,  I really appreciate.

after so many investigation and I found out it was due to backend Office 2019 patches 16.0.10359.20023 didn't apply properly in my laptop,  this morning I re-install again and everything back to normal. Yah!

anyway I was attempting to demonstrate to my colleagues two methods of appending multiple worksheets using UI, i.e.  Get Data > from Excel and using mouse to select all the 24 worksheets into PQ,  then append as new,  the timing will be about 3-5 mins  vs using  M code  Excel.WorkBook ()  or Excel.CurrentWorkbook(),  which a lot of users won't dare to venture into it,  it is a matter of getting use to it,  understand the coding algorithm

Cheers !!!