Hi,

I use Excel XP with Pivottables with MSAS2000 + NT_User Authorisation.

When I save the excel sheet and open this on any PC the last saved data
is always shown first.

I know you can have Refresh Excel from MSAS2000 in the pivottable but
if an user press no automatic refresh than the data as saved is shown
and not the data as should be shown based on his account.

Any idea if it is possible to save Excel without data and/or if it is
possible to have the popupbox refresh pivottable automatic / not
automatic never shown for the user ?

Regards, Marco
www.gmsbv.nl

Marco

I thought I would include the suggestion I sent you offline in case
anyone else was watching this thread.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
====

You could do it with a macro in the open event of the workbook, but the
macro would need to be signed or the security level set to low in excel
so that the users did not get prompted to "allow macros", because if
they choose to disable macros, then the refresh will not run.

The following code is all that would be required, if you want the update
to be completely silent you can remove the calls to
Application.StatusBar, I just put this in so that I could see it
working.


Sub RefreshAllPivotTables()
Dim MySht As Worksheet
Dim pt As PivotTable

For Each MySht In ThisWorkbook.Worksheets
For Each pt In MySht.PivotTables
pt.PivotCache.Refresh
Application.StatusBar = "Updating " & pt.Name
Next
Next
'\\ reset the status bar
Application.StatusBar = False

End Sub


In article <1137062747.967519.292620 (AT) o13g2000cwo (DOT) googlegroups.com>,
olap (AT) gmsbv (DOT) nl says...