calculate

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

just a quickie - is it possible to turn calculation off on
just one sheet in a work book? It is very frustraiting
that every cell I type in one sheet causes every cell in
the entire workbook to be recalculated, but I still want
formula in the active sheet to be calculated. at the
moment I get around it by pasting the values in all the
other sheets - but this means that if I want to update
them, I have to re-copy all the formula in.
any hints appreciated

Pete
 
Hi Pete
you may use the WOKRBOOK setting for calculation. Goto 'Tools -
Options - Calculation' and choose 'manual calcualtion'
But this affects the entire workbook not just a single sheet!
 
Hi Pete,

you can disable calculation for a sheet using VBA:

Worksheets("ComplexSheet").enablecalculation=false
(this setting is not saved with the workbook)

you can also switch calculation to manual and calculate only the active
sheet by pressing Shift-F9


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
This is great for one sheet or workbook, but I am desperate for help on my transition from Office 97 to xp in the fact that when I open a workbook it automatically calculates or updates external links. As I use a link to another program through Excel it basically puts all of my files into named ranges!

Please can you help?
 
Hi Matthew,

assuming that you did not have this problem with Excel97 it could be caused
by the fact that Excel 2002 recalculates a workbook that was last calculated
by a previous excel version.
If this is the problem then if you calculate the workbook with excel 2002,
switch to Manual mode and then save it you should be OK next time you open
it.

Another explanation could be that excel sets its calculation mode from the
first workbook opened, so if you have a workbook opened in automatic mode
and then open a workbook that was saved in manual mode, the "manual"
workbook will recalculate.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

Matthew said:
This is great for one sheet or workbook, but I am desperate for help on my
Click to expand...
transition from Office 97 to xp in the fact that when I open a workbook it
automatically calculates or updates external links. As I use a link to
another program through Excel it basically puts all of my files into named
ranges!!
 
Charles

Please forget my first post as I re-read the second paragragh - followed it to the letter and now I can read my old files. You are a genius, a gentleman and a scholar. Thanks for your help this has been annoying me for over a month and my IT guys could not help

Thanks once agai

Matthew
 
Back
Top