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

P

Pat

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?
 
G

Garreth Lombard

Hi there Pat,

I assume you are using office 2003,

You might want to set your calculations to manual.
Tools>Options>Calculations : Then set to manual


Hope this works for you

Regards

Garreth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
How do I make cell references return to normal? 4
Excel color-formatted text previews & prints in black 0
Excel Bug 0
Excel opening MSSynch in 2010? How to stop it? 0
How do I stop Excel from copying date format from cell above? 2
Excel 2010 Conditional Formatting 2
The view colors in Excel 2003 cells change from color to black 2

Top