How to share workbook (read only)

[anon]

Hello,

I want to share a workbook so that many people can view it and see live changes but only one person can actually make changes. In other words, other people can't edit/save anything.

How do I do this?

Thanks!

[FDibbins]

save the file with a password, but set it as read-only. That way, anyone can open it, they can even change stuff, but will not be allowed to save it

[anon]

save the file with a password, but set it as read-only. That way, anyone can open it, they can even change stuff, but will not be allowed to save it

But if I make a change, will they be able to see me make a change in their read only workbook? Or do they have to re-open it.

[FDibbins]

they would have to reload (I dont think F9 will work)