Formula displays, not value
 

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?

Formula displays, not value
 

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

"aramancam" wrote:

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?

Formula displays, not value
 

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.
--
Sam


"aramancam" wrote:

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?

Formula displays, not value
 

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

"SamIAm" wrote:

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.
--
Sam


"aramancam" wrote:

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?

Formula displays, not value
 

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 EditReplace

What: = sign

With: = sign

Replace all.


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 20:48:01 -0700, Kimo wrote:

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

"SamIAm" wrote:

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.
--
Sam


"aramancam" wrote:

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?

Formula displays, not value
 

Hey Gord,

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

"Gord Dibben" wrote:

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 EditReplace

What: = sign

With: = sign

Replace all.


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 20:48:01 -0700, Kimo wrote:

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

"SamIAm" wrote:

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.
--
Sam


"aramancam" wrote:

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?

Formula displays, not value
 

On 26 Jul, 17:50, Kimo wrote:
Hey Gord,

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

"Gord Dibben" wrote:
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 EditReplace

What: = sign

With: = sign

Replace all.

Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 20:48:01 -0700, Kimo wrote:

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

"SamIAm" wrote:

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.
--
Sam

"aramancam" wrote:

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?

Kimo,

The cell in the first work book; does it display

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

Matthew

Formula displays, not value
 

Hey Mathew,

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

"Matthew" wrote:

On 26 Jul, 17:50, Kimo wrote:
Hey Gord,

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

"Gord Dibben" wrote:
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 EditReplace

What: = sign

With: = sign

Replace all.

Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 20:48:01 -0700, Kimo wrote:

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

"SamIAm" wrote:

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.
--
Sam

"aramancam" wrote:

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?

Kimo,

The cell in the first work book; does it display

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

Matthew