#1   Report Post  
Posted to microsoft.public.excel.misc
Bryan
 
Posts: n/a
Default Shared Workbook

I have a question that I hope will be fairly simple. I have a shared
workbook on a public drive that several people change. There is a password
upon opening the workbook....and users who don't have the password will have
to view as Read Only.

If a user opens this up as Read Only and keeps this spreadsheet open during
the day.....what can I do to make sure data refreshes for this user as it is
changed by somebody with full access? I've been told that even if I set my
shared workbook to update every 5 minutes......users who have this Read Only
will not get these updates.

Any suggestions on what my best options are?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Shared Workbook

I shared a workbook.

I opened a second copy in a second instance of excel as read only.

I opened a third copy in a third instance of excel (read/write).

I set the time to update to 5 minutes.

I made some changes to the original instance and saved. I waited 5 minutes and
the 2nd (readonly) didn't show the changes. The third (read/write) showed them.

I think you've been told correctly (well, for at least xl2003 where I tested).

Maybe make it a training issue--remember to close and reopen your workbook
before you trust it???

Bryan wrote:

I have a question that I hope will be fairly simple. I have a shared
workbook on a public drive that several people change. There is a password
upon opening the workbook....and users who don't have the password will have
to view as Read Only.

If a user opens this up as Read Only and keeps this spreadsheet open during
the day.....what can I do to make sure data refreshes for this user as it is
changed by somebody with full access? I've been told that even if I set my
shared workbook to update every 5 minutes......users who have this Read Only
will not get these updates.

Any suggestions on what my best options are?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared Workbook Protection Mike Excel Discussion (Misc queries) 1 January 24th 06 04:38 PM
In a shared workbook, can only one person "accept or reject" chang pama Excel Discussion (Misc queries) 0 September 8th 05 01:45 PM
Removing shared workbook protection Thore Excel Discussion (Misc queries) 3 June 30th 05 12:11 AM
Sorting in a shared workbook Mark Jackson Excel Discussion (Misc queries) 1 June 7th 05 01:43 PM
Shared workbook Trish Lockhart Excel Discussion (Misc queries) 0 April 12th 05 07:02 PM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"