Share via

Excel QueryTable Refresh stopped working after Office update

Anonymous
2018-01-26T19:57:03+00:00

After last Office update, QueryTable.Refresh function stopped working on my mac.

Here is the way how I use the refresh: Worksheets("xxx").QueryTables.Item("yyy").Refresh

VBA throws 1004 error: Application-defined or object-defined error. 

This happens only when Background refresh is disabled. 

Any way to make it working again?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Jim G 134K Reputation points MVP Volunteer Moderator
2018-01-28T16:05:57+00:00

There's something wrong with Background refresh setting in the update. Please click the Smile button in Excel to let Microsoft know you are affected by this problem. Thanks.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-01-27T09:56:33+00:00

    Hi Alex,

    To have a better understanding about your scenario, please share with me more info about this issue:

    1. How do you create your query and which kind of database you are using?
    2. The version number of your Office(Excel>About Excel) and OS(Apple menu>About this Mac). Screenshot of the error message you received.
    3. Does this issue happen to all queries? Can you refresh your query after you enable Excel background refresh?
    4. Does this issue happen when you create a new query?

    Thanks,

    Neo

    Was this answer helpful?

    0 comments