Cells not calculating until f2 is used to edit cell
 

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.

Cells not calculating until f2 is used to edit cell
 

Tools/ Options/ Calculation
Set to Automatic, not Manual.
--
David Biddulph

"MB" wrote in message
...
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.

Cells not calculating until f2 is used to edit cell
 

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

"MB" wrote in message
...
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.

Cells not calculating until f2 is used to edit cell
 

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

"MB" wrote in message ...
| 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
|
| "MB" wrote in message
| ...
| 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.
|
|
|
|
|

Cells not calculating until f2 is used to edit cell
 

Thanks Niek...very interesting.

"Niek Otten" wrote:

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

"MB" wrote in message ...
| 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
|
| "MB" wrote in message
| ...
| 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.
|
|
|
|
|