Can not edit query after update excel to Monthly channel office

Question

Hi,

I have a excel with query and able to edit it, but I can not do that after been updated to Monthly Channel office, can you please advise?

Regards

Steven

Answer 1

Hi Steven,

To have a deep understanding about your scenario, please share with me the following info:

1. Does this issue happen to all workbooks or particular workbook?
2. Can you edit query normally after you set up Excel in safe mode?(Hold CTRL key and click workbook.) If so, that means this issue may be caused by Add-ins. You can open the workbook normally and click File>Options>Add-ins to disable your Add-ins one by one to check which one caused this issue.
3. Does this issue still exist if you remove this query and add it again?
4. Can you edit query normally when you create a blank workbook and add a query to connect the same database?

Please also share with me the previously and new version number of your Office(File>Account>Product Information), OS(Win+R>type CMD) your previously update channel and the type of your Office 365 subscription(Sign in your account in portal>Click your name>My account>Subscriptions).

Thanks,

Neo

Answer 2

Hi Steven,

Have you tried my advice to rebuild a query for your workbook? Can you edit your query now? Please share with me your recent progress.

Thanks,

Neo

Answer 3

Hi Neo,

1. It is to all workbooks.
2. Still can not edit in safe mode.
3. yes, I created a new file and query.
4. No, can not.

Here is old version,

Here is current version,

OS,

Regards

Steven

Information has been removed according to Privacy Policy.

Answer 4

Hi Steven,

Thanks for your reply.

To have a deep understanding about your scenario, please share with me the following info:

1. The detailed steps that you created this query.
2. Which database you are using.
3. What have you changed before this issue happens? (Except change channel)

Thanks,

Neo

Answer 5

Hi Steven,

Can you edit your query normally now? Please share with me your recent progress.

Thanks,

Neo