RefreshAll in a shared workbook

T

Telobamipada

I have a workbook (MS Office 2003) which is shared amongst several users. I
have certain users I would prefer only had view access. I also need for them
to be able to refresh the data as it is manipulated by the others. I have
tried to use a macro to
"RefreshAll" which works fine until the workbook is shared... any takers?
Thanks!!!
 
D

Dave Peterson

Look in Excel's help (not VBA's) for "Features that are unavailable in shared
workbooks". You'll see a bigl list--including:

Create or change PivotTable reports You can view existing reports.

(Using VBA doesn't make this restriction go away--as you've seen.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why macro cannot refreshall? 7
Outlook mail shared questions 0
Shortcuts in OneDrive 0
vba code does not run 3
Different rights to editing and for adding a text for online shared version of MS word 0
Hooking into Refresh/RefreshAll events from listobject 3
ThisWorkbook.RefreshAll Issue/Question 1
Visual Basic in a shared workbook 4

Top