formulas not calculating

patl

Board Regular
Joined
Dec 15, 2005
Messages
123
Formulas on my sheet only calcuate when i click on each individual cell, but just hitting Shift+F9 doesnt do anything. Does anyone know the cause of this? Is there any way to correct it? Thanks for any info.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

patl

Board Regular
Joined
Dec 15, 2005
Messages
123
well, the workbook is too big to keep calcuations on and i have some macros running so i keep it off, then calculate the pages individually.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,110
Messages
5,570,250
Members
412,313
Latest member
pauloalex
Top