Protect the cells that contain formulas and data that you want protected.
Even if a user saves the worksheet after making changes, the changes will not
be to protected material.
--
Gary''s Student - gsnu200785


"Kevin" wrote:

Hi,
I have some formulas and data which is shared for the users to get their
answers instantly. Is there any way not to allow users to save the excel
shared file if they make any changes. Is it possible if the users close the
file with some changes excel exit without prompting or saving??. i tried read
only, protect sheet etc. its of no use.
Thanks
Kevin