RefreshAll in a shared workbook
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!!! -- If you can read this, thank a Teacher... If your reading it in english, thank a Veteran! |
RefreshAll in a shared workbook
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.) Telobamipada wrote: 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!!! -- If you can read this, thank a Teacher... If your reading it in english, thank a Veteran! -- Dave Peterson |
All times are GMT +1. The time now is 05:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com