Calculations

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.
 
A

Alan

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Excel formula help for calculating freight. 2
Calculating nr of books a certain author has published 2
Calculate end date and time 1
What Multiple functions do I need? 2
Calculate After hours 3
Calculate the median value before a specified list 0
IF validation for time totaling 2

Top