Skip to Content
0

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

Jan 05 at 08:59 AM

63

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Torsten Wirth Jan 10 at 09:50 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded