Items in Workbook won't calc

G

Guest

I have a workbook with several sheets that reference each other and some
simple math on each. I have auto calc on, but at times I find formulas that
will not update. I have tried F9 and as I said the auto calc is on. I have
to reimput the formula or click in the cell and hit enter to recalc.

Any solutions would be GREATLY appreciated.

Thanks,
Eric
 
N

Niek Otten

Hi Eric,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a workbook with several sheets that reference each other and some
| simple math on each. I have auto calc on, but at times I find formulas that
| will not update. I have tried F9 and as I said the auto calc is on. I have
| to reimput the formula or click in the cell and hit enter to recalc.
|
| Any solutions would be GREATLY appreciated.
|
| Thanks,
| Eric
 
G

Guest

replace "=" with "=" seemed to work.

The site you posted is a great reference. Thanks!

Eric
 

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

auto calc on, but have to edit (f2) cells to force re-calc..help! 3
Workbook causes calculation errors 2
SUM Formula 2
Calc 2
Automatic Recalc 1
Help: vlookup from multiple sheets and spreadhseets 1
Formulas stopped working - Auto Calc IS on... 1
Charts not updating 1

Top