exel

  • Thread starter Thread starter opo50
  • Start date Start date
O

opo50

I have established calculators in exel to extrapolate material cut sizes from
a variable base size.
I loced the workbook to protect the information, and when it was unlocked,
the information will not flow across pages or cells???
Can anyone advise?
 
Suspect that the calc mode got inadvertently toggled to manual. Press F9,
does it "flow" okay? To check/change calc mode, click Tools > Options >
Calculations tab
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
 
Hi,

If you are using 2007 the command to turn on automatic recalculation is
Formulas, Calculation Options, Automatic.

I second the question about things not "flowing". Protecting the
spreadsheet has no effect on calculation.
 
Back
Top