Now what?

  • Thread starter Thread starter Intelligence3
  • Start date Start date
I

Intelligence3

Okay, for some reason now, whenever I enter a formula in a cell, it
won;t let me paste the forumla elsewhere and automatically give me a
result.

For example, I have :

Big Big
Bug bug
Beg Beg
Bog Swamp

If I enter

Big Big =EXACT(A1,B1)
Bug bug
Beg Beg
Bog Swamp

I get :

Big Big TRUE
Bug bug
Beg Beg
Bog Swamp


If I copy the formula cell, and either drag-fill or paste it in the
cells below, I get

Big Big TRUE
Bug bug TRUE
Beg Beg TRUE
Bog Swamp TRUE

But looking at the cells themselves shows that I have

Big Big =EXACT(A1,B1)
Bug bug =EXACT(A2,B2)
Beg Beg =EXACT(A3,B3)
Bog Swamp =EXACT(A4,B4)

If I click on one of the cells that should be False, select the formula
line, the hit ENTER, I get the proper result, likewise if I click on the
formula button.

What on earth did I do? I use this a lot.

Help me Obi-Wan Kenobi, you're my only hope.
 
Never mind, i figured out the right search terms to find the answer in
this forum. The calculations were on manual, apparently one of the
documents I had opened earlier was on manual, and that apprently resets
the preference. Jeepers.

I wish I hadn't lost 2 hours to this. :)
 
Back
Top