482      人物

Can not edit query after update excel to Monthly channel office

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

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

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

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.

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

Hi Steven,

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

Thanks,

Neo

最後更新：2018-01-04 22:04:33

  上一篇： win10，成功安裝並打開office，但是打不開visio/project，操作係統的當

  下一篇： 預覽體驗修複失敗