HI,
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich

Try

goto Edit-LINKS-CHANGE SOURCE and there select the same file on which you
are working...the file references will automatically disappear

however for this you first have to save the file on which you are working

Courtesey - http://www.ozgrid.com/forum/showthread.php?t=49165

"AusTexRich" wrote:

HI,
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich

One way is to change all the formulas to text.

Select all the cells
edit|replace
what: =
with: $$$$$=
replace all

Then copy the sheet to the new workbook.

Then fix up both sheets.

Select all the cells
edit|replace
what: $$$$$=
with: =
replace all

===========
Another way is to let the link back to the "sending" workbook be created, then
use Edit|Links (in xl2003 menus) to point the link to the current file.

AusTexRich wrote:

HI,
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich

--

Dave Peterson

Use EditReplace ..
In source sheet: Replace "=" with say "zzzzzzz"
Do the copy paste
Then restore with reverse: Replace "zzzzzzz" with "="
in both destination & source
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"AusTexRich" wrote:
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich

That will work just fine.
Thanks
--
AusTexRich


"Sheeloo" wrote:

Try

goto Edit-LINKS-CHANGE SOURCE and there select the same file on which you
are working...the file references will automatically disappear

however for this you first have to save the file on which you are working

Courtesey - http://www.ozgrid.com/forum/showthread.php?t=49165

"AusTexRich" wrote:

HI,
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich

Works fine.
Thank you very much for your help.
--
AusTexRich


"Max" wrote:

Use EditReplace ..
In source sheet: Replace "=" with say "zzzzzzz"
Do the copy paste
Then restore with reverse: Replace "zzzzzzz" with "="
in both destination & source
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"AusTexRich" wrote:
I'd like to Copy an entire worksheet from one file to another, but, I don't
want the file name to appear in the cell after Paste. For example
=[myfile.xls]Myworksheet!E5, I'd like to see only the cell reference:
Myworksheet!E5.

How can I get Excel do that?
--
AusTexRich

Welcome, thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik
---
"AusTexRich" wrote in message
...
Works fine.
Thank you very much for your help.
--
AusTexRich