刷新功率转换窗口 [英] Refresh Power Pivot Window
问题描述
如果在打开excel文件时自动刷新Power Pivot窗口,而不在power pivot选项卡中选择 Power Pivot Window
选项?
How to automatically Refresh Power Pivot Window when i open excel file , without going the Power Pivot Window
option in power pivot tab?
推荐答案
Vinoth
可以写VBA,通过放置代码来触发刷新所有在Workbook模块中,并使用Open_Event在工作簿打开时触发它。
It is possible to write VBA that triggers a 'refresh all' by placing the code in the Workbook module and using the Open_Event to trigger it as the workbook is opened.
如果您使用的是2010,那么您将需要使用由名叫 Tom Gleeson 的人。
If you are using 2010 then you will need to use this highly innovative technique developed by a guy called Tom Gleeson.
如果您使用的是2013,那么随着数据模型正式暴露给VBA,事情变得更加直接。有几个资源包括这个。
If you are using 2013 then things become more straightforward as the data model is formally exposed to VBA. There are several resources out there including this.
HTH
雅各布
HTH Jacob
这篇关于刷新功率转换窗口的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!