Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbook Protection | Excel Discussion (Misc queries) | |||
In a shared workbook, can only one person "accept or reject" chang | Excel Discussion (Misc queries) | |||
Removing shared workbook protection | Excel Discussion (Misc queries) | |||
Sorting in a shared workbook | Excel Discussion (Misc queries) | |||
Shared workbook | Excel Discussion (Misc queries) |