cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

torsten_wirth
Participant
0 Kudos

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.