Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


After certain edits in PowerPivot in Excel 2013, Power Query connections are read-only and further editsĀ are blocked in Power Query.

More Information

After you applyOctober 13, 2015, update for Office 2013 (KB3039800), September 8, 2015, update for Office 2013 (KB3039739) and MS15-099: Description of the security update for Excel 2013: September 8, 2015 (KB3085502), the edits are blocked and Power Query can change the queries in these connections. The following actions in PowerPivot are blocked for tables that are loaded by using Power Query:

  • Delete columns

  • Rename columns

  • Change the data type of a column

  • Delete tables

  • Rename tables

When you try to do these actions, you will receive the following error message:

This table was created with Power Query. To change this table, use Power Query instead.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!