Formulas

[Sue H]

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.

 

[Paul]

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.

Tools > Options > Calculation tab
Is calculation is set to automatic?

 

[Peo Sjoblom]

Look under tools>options>calculations, most likely you have it set to manual
calculation, check automatic instead

--

Regards,

Peo Sjoblom

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.