有无快截键或者简单的VBA代码，让工作博里所有的数举透视表全部更新。谢谢

dj100 · 发表于 2005-7-18 11:32

有无一次性的快截键或者简单的VBA代码，让工作博里所有的数举透视表全部更新。比方F9，谢谢

boss 只要一按，所有的数剧透视表全更新了。

asdf1001 · 发表于 2005-7-18 12:27

Dim pc As PivotCache For Each pc In ThisWorkbook.PivotCaches pc.Refresh Next

dj100 · 发表于 2005-7-18 13:39

thank you very much

dj100 · 发表于 2005-7-18 13:47

For Each pc In ThisWorkbook.PivotCaches

VBA says this sentence is wrong.

could you help me again?

thank you.

dj100 · 发表于 2005-7-18 13:49

error is 50290.

dj100 · 发表于 2005-7-18 13:51

pc=nothing.

is it wrong?

asdf1001 · 发表于 2005-7-18 14:11

我的机器没有问题 WINXP OFFICE XP

dj100 · 发表于 2005-7-18 14:53

thank you. now it works when i am back home.

Long_III · 发表于 2005-7-18 12:05

录制一个宏看看代码

		自动登录	找回密码
密码			免费注册