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?