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?

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?

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?

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

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?

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?

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

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