Prev: Formula returned instead of result
Next: don't want cell numbers to change when pasting formulas
From: Perplexed on 18 May 2010 14:24
I am generating a spreadsheet in excel 2007 and sending it to one of my subs.
They then take info from my sheet and from another sheet and link it to a
third sheet that is in excel 2003. The problem arises when she sends the
spreadsheet with the new links back. We open the sheet in 2007 and we the
pound sign and the word value instead of the new linked number. We have tried
to open the sheet in the 2003 compatibality mode but that will not work. Any
Ideas.
From: trip_to_tokyo on 18 May 2010 14:56
"Any Ideas"

Yes: stop switching between the versions; you are asking for trouble.



"Perplexed" wrote:

> I am generating a spreadsheet in excel 2007 and sending it to one of my subs.

> They then take info from my sheet and from another sheet and link it to a
> third sheet that is in excel 2003.

The problem arises when she sends the
> spreadsheet with the new links back.

We open the sheet in 2007 and we the
> pound sign and the word value instead of the new linked number.

We have tried to open the sheet in the 2003 compatibality mode but that
will not work. Any
> Ideas.
 | 
Pages: 1
Prev: Formula returned instead of result
Next: don't want cell numbers to change when pasting formulas