Copy, paste without file name referenced after paste

[AusTexRich]

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?

 

[Sheeloo]

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

 

[Dave Peterson]

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.

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?

 

[Max]

Use Edit>Replace ..
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]

That will work just fine.
Thanks
--
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

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

Use Edit>Replace ..
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
---

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?

 

[Max]

Welcome, thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik