Cell doesn't do calculation until you force it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There is a formular on the cell, simply referring to another cell on a
different sheet and do some calculation. Somehow it doesn't do it
automatically and showing 0, until I click on the cell, then click on
formular cell on toolbar then click on the sheet again. Now the value appears.

Does anyone know what's the problem? Is there any simple command to refresh
all the values on a worksheet?

strout
 
Tools - Options - calculation - set calculation to automatic

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help
 

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

Problem with external data and #reference error 2
Highly specific Exell Problem 5
converting text to number 5
Cell Toolbar Dilemma xl2013 13
Force Recalc 3
DO Until Loop 2
Do Until Loop 1
do until loop 2

Back
Top