Skip to Content
avatar image
Former Member

Analysis for Office - How to only refresh one sheet when severeal queries active on multiple sheets

I have a workbook in Analysis for Office with several different queries on several sheets.

How do I control the Refresh option, so it only refreshed one sheet and not all queries in the workbook?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 10 at 09:50 AM

    You can do that via refreshing source by source or you can do the same via VBS coding e.g. via a button which refreshes all sources you would like to refresh. There is no direct Option for resreshing a sheet.

    Add comment
    10|10000 characters needed characters exceeded