Hi. We have a shared workbook which is accessed by a group of 10-12 users for editing, and can be saved numerous times throughout the day.
We want to be able for everyone (up to 100 users) to see this read-only, so we were looking at saving it as a web page without interactivity. Due to the number of updates and saves throughout the day, we would want it to republish each time it was updated/saved, so that everyone could see the latest version on refreshing the web page.
I'm using Excel 2003, and cannot find a way to save as a web page WITHOUT interactivity but WITH autorepublish. Is this possible?
If not, are there alternative methods of achieving what we're after? Would it be better to allow everyone access to the workbook, but to password-protect it for editing?
Thank you, Steve.