Calculations

  • Thread starter Thread starter Steve Z
  • Start date Start date
S

Steve Z

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.
 
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
 
Back
Top