Is there a way to disable calculations totally? I have a multi-book sheet
with numerous links and formulas that I want to share, without having to
create a "values" version of the sheet.

Tools Options Calculation tab. Check 'Manual' OK. You can calculate
manually by hitting F9
Regards,
Alan.

"Steve Z" <Steve wrote in message
...
Is there a way to disable calculations totally? I have a multi-book sheet
with numerous links and formulas that I want to share, without having to
create a "values" version of the sheet.

Not as far as I know.

You would be at the mercy of the calculation options of the recipient.

What is your intent?

To let users see how the worksheet formulas are constructed?

You could use a macro to create a sheet with the non-calcuable formulas,
where they are located and what references they use then convert all the
other sheets to values.


Gord Dibben MS Excel MVP

On Fri, 27 Mar 2009 11:28:03 -0700, Steve Z <Steve
wrote:

Is there a way to disable calculations totally? I have a multi-book sheet
with numerous links and formulas that I want to share, without having to
create a "values" version of the sheet.