Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm copying formulas from worksheet to worksheet w/in the same book. The formulas do copy, but the results/answers don't appear in the cells until I hit "save." Why? I've done this millions of times, and never came across this.
 
Sue H said:
I'm copying formulas from worksheet to worksheet w/in the same book. The
Click to expand...
formulas do copy, but the results/answers don't appear in the cells until I
hit "save." Why? I've done this millions of times, and never came across
this.

Tools > Options > Calculation tab
Is calculation is set to automatic?
 
Look under tools>options>calculations, most likely you have it set to manual
calculation, check automatic instead

--

Regards,

Peo Sjoblom


Sue H said:
I'm copying formulas from worksheet to worksheet w/in the same book. The
Click to expand...
formulas do copy, but the results/answers don't appear in the cells until I
hit "save." Why? I've done this millions of times, and never came across
this.
 
Back
Top