Formula displays, not value

[Guest]

I am linking two files by having cells in one spreadsheet equal to
corresponding cells in another. However when I enter the equal sign in one
sheet, then go to the other sheet and click on the corresponding cell then
hit enter, the original cell displays the formula, not the value. I tried
copying cells above which display correctly, but that does the same thing.
Any ideas how to solve this problem?

 

[Guest]

Check whether or not cell is text: if it is, it will show formula not result.

 

[Guest]

Evening. Make sure that your calculations haven't been switched to "manual"
by the gremlins (an errant keystroke). Go to Tools/Options/Calculations.
Each time this has happened to me, that's been the culprit.

 

[Guest]

Hi there, I'm having the same problem with cell copying. Calculations is set
to automatic, the format is set to date and the cell I'm copying from is the
same, any other suggestions? Thanks

 

[Gord Dibben]

Kimo

Perhaps the receinving cells are formatted as text.

Format to General then F2 and ENTER to re-enter the formula.

Or you have View Formulas enabled.

Hit CTRL + ` (backquote above Tab key) to toggle out of formula view.

Another trick.................select the cells and Edit>Replace

What: = sign

With: = sign

Replace all.


Gord Dibben MS Excel MVP

 

[Guest]

Hey Gord,

Tried all 3 of your sugestions, still doesn't work.

 

[Matthew]

Hey Gord,

Tried all 3 of your sugestions, still doesn't work.

Kimo,

The cell in the first work book; does it display

=[Book1.xls]Sheet1!$a$1 ?

Matthew

 

[Guest]

Hey Mathew,

I'm just working with one workbook with 27 sheets.

Hey Gord,

Tried all 3 of your sugestions, still doesn't work.

Kimo,

The cell in the first work book; does it display

=[Book1.xls]Sheet1!$a$1 ?

Matthew