Cells not calculating until f2 is used to edit cell

[MB]

Im using a large spreadsheet using add-in formulae - After calculation, it
leaves large numbers of cells which require me to go in and manually edit
them using F2 - I only need to press F2 then enter and the cell will then
change. Is there a way round this? Is it a bug within excel?

Ive noticed this sometimes with normal (Non add-in) formulae.

 

[David Biddulph]

Tools/ Options/ Calculation
Set to Automatic, not Manual.

 

[MB]

Hi....the spreadsheet is too large to set to auto calc - It's better for me
to press F9 when needed....however...pressing F9 should calculate the cells
in question?!...but it doesnt!!

 

[Niek Otten]

I don't know exactly what you mean by add-in formulas, but, when checking this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

pay special attention to the section about UDFs

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi....the spreadsheet is too large to set to auto calc - It's better for me
| to press F9 when needed....however...pressing F9 should calculate the cells
| in question?!...but it doesnt!!
|
| "David Biddulph" wrote:
|
| > Tools/ Options/ Calculation
| > Set to Automatic, not Manual.
| > --
| > David Biddulph
| >
| > | > > Im using a large spreadsheet using add-in formulae - After calculation, it
| > > leaves large numbers of cells which require me to go in and manually edit
| > > them using F2 - I only need to press F2 then enter and the cell will then
| > > change. Is there a way round this? Is it a bug within excel?
| > >
| > > Ive noticed this sometimes with normal (Non add-in) formulae.
| > >
| > >
| >
| >
| >

 

[MB]

Thanks Niek...very interesting.