I doubt Microsoft views this type of thing as a bug, but in contrast, this
is a design decision. This is how the software was designed to operate. If
you think a change to the design is warrented, then you need to voice your
opinion at



Other than that, it is just a wish and no one will hear it.

An obvious, but not necessarily satisfactory solution is to use the
beforeclose or beforesave event to make a static copy of the worksheets
where you want to review the closing values.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Thanks for your input guys. I guess this means it isn't possible. I
can only hope that someone from Microsoft spots these bugs and fixes
them in future versions. I have always thought that the calculation
mode should be a workbook specific setting and not an application
setting. We should be able to have multiple workbooks open each with
different calculation settings.

Stuart