Locking the Update Feature

[Joe]

I have set up an order form which looks up various values
from other pages, as well as updates the date [TODAY()].
The people whom I send the form to only care about the
values as they are represented on that day. Is there any
way to save a worksheet so that will not ask if you want
to update or to save the file (because of the date
function)? Is there an easier way then copying the
entire sheet and pasting special/ values only?

Thanks

 

[Dave Peterson]

That sounds like the easiest way to me.

I have set up an order form which looks up various values
from other pages, as well as updates the date [TODAY()].
The people whom I send the form to only care about the
values as they are represented on that day. Is there any
way to save a worksheet so that will not ask if you want
to update or to save the file (because of the date
function)? Is there an easier way then copying the
entire sheet and pasting special/ values only?

Thanks

 

[Jonathan Rynd]

Is there any
way to save a worksheet so that will not ask if you want
to update or to save the file (because of the date
function)?

Do you mean saving the spreadsheet as read-only? In that case the users
wouldn't be able to save changes to it.