F2

  • Thread starter Thread starter ab
  • Start date Start date
A

ab

I have a workbook here with multiple tabs. If I update one tab by changing
the number in it, it does not calculate automatically without hitting the F2.
The calculation function is set to automatic. Whats going on?
 
Sounds like you have a macro in there. If you go to Tools - Macros - Visual
Basic Editor, look to the top left. If you see a folder named Modules, you
have a macro in there. You can right-click on the module within this folder
and click remove module....
 

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

Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" 2
how do I stop re-calculated fields in excel from going "black" 1
Automatic calculation is not working 4
excel cells changing to "#VALUE!" whenever another file is opened 8
Cells not calculating until f2 is used to edit cell 4
Sheet Names and Auto-calculation 2
Changing format 2
Excel recalculation 3

Back
Top