Break Power Query Connection but keep data untouched?

[Bryan123]

I have an excel workbook that connects to 6 other excel workbooks via Power Query.  I would like to break that connection and keep the data untouched.  That way if the workbook ever gets moved or what not, the data will always remain.

What is the best and quickest way to accomplish this?  Just go into all 6 tables and convert to range or unlink them?  Any quicker way?

[#2 · Accepted solution]

@Bryan123 

Best or not depends on goals. Both require same time - right click on the table and in Table select Convert to range or Unlink. The difference is that in second variant you keep structured table instead of range.

[#3]

Thank you. I have a ton of workbooks like this that I would like to break the connection so just wanted to know the best way. Was hoping I could break all connections in a workbook at once instead of one at a time.

[#4]

@Bryan123 

Please check this Re: Office 365 - Delete data connections in one go - Microsoft Tech Community thread, perhaps something will be useful.