Copy, paste without file name referenced after paste

A

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?
 
D

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?
Click to expand...
 
M

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
 
A

AusTexRich

That will work just fine.
Thanks
--
AusTexRich


Sheeloo said:
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 said:
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?
Click to expand...
Click to expand...
 
A

AusTexRich

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


Max said:
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 said:
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?
Click to expand...
Click to expand...
 
Top