exel

[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?

 

[Max]

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

 

[ShaneDevenshire]

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.