how do I stop re-calculated fields in excel from going "black"
 

When I change any cells in my excel spreadsheet and the sheet re-calculates
any affected cells go black i.e. I can't see the new calculated figures in
these cells? If I hit "F2 and then enter" the cell goes back to normal i.e I
can see things normally?

how do I stop re-calculated fields in excel from going "black"
 

Hi there Pat,

I assume you are using office 2003,

You might want to set your calculations to manual.
ToolsOptionsCalculations : Then set to manual


Hope this works for you

Regards

Garreth
--

Thank you and Regards

Garreth Lombard


"Pat" wrote:

When I change any cells in my excel spreadsheet and the sheet re-calculates
any affected cells go black i.e. I can't see the new calculated figures in
these cells? If I hit "F2 and then enter" the cell goes back to normal i.e I
can see things normally?