How come when I copy and paste special 'values' the following concatenated
string,

="='H:\Test\[" & D150 & ".xls]BUYERS REQUEST'!$C$44"

I get

='H:\Test\[PRDtemplate_Rev9.2_8-11-06-TEST.xls]BUYERS REQUEST'!$C$44.

I would actually like excel to automatically recognize that it is a formula,
and return the linked value (i.e. $8.75) and not the actual formula. Is
there a way to do this without going into the cell and hitting enter to get
the desired value.

If you want to make excel see it as a formula, you have to make a change.

I'd select the range and do
edit|Replace
what: = (equal sign)
with: = (equal sign)
replace all

to get lots of cells all at once.

Kaby wrote:

How come when I copy and paste special 'values' the following concatenated
string,

="='H:\Test\[" & D150 & ".xls]BUYERS REQUEST'!$C$44"

I get

='H:\Test\[PRDtemplate_Rev9.2_8-11-06-TEST.xls]BUYERS REQUEST'!$C$44.

I would actually like excel to automatically recognize that it is a formula,
and return the linked value (i.e. $8.75) and not the actual formula. Is
there a way to do this without going into the cell and hitting enter to get
the desired value.

--

Dave Peterson

Wow...thanks a bunch Dave...that seem to work and is much less
repetitive...you've been a real help.

"Dave Peterson" wrote:

If you want to make excel see it as a formula, you have to make a change.

I'd select the range and do
edit|Replace
what: = (equal sign)
with: = (equal sign)
replace all

to get lots of cells all at once.

Kaby wrote:

How come when I copy and paste special 'values' the following concatenated
string,

="='H:\Test\[" & D150 & ".xls]BUYERS REQUEST'!$C$44"

I get

='H:\Test\[PRDtemplate_Rev9.2_8-11-06-TEST.xls]BUYERS REQUEST'!$C$44.

I would actually like excel to automatically recognize that it is a formula,
and return the linked value (i.e. $8.75) and not the actual formula. Is
there a way to do this without going into the cell and hitting enter to get
the desired value.

--

Dave Peterson