Copying Worksheets

  • Thread starter Thread starter Anne Cherrington
  • Start date Start date
A

Anne Cherrington

Hi There,

Can anyone help....

I am trying to copy a worksheet with formulas etc from one
xls file to another...

The only thing is, is that when I copy it the formulas
between the files, the formulas in the copied version are
automatically updated to include the reference to the
orgininating spreadsheet file...

All I want to do is copy a worksheet with the formulas etc
from one spreadsheet to a different spreadsheet. I don't
want the formulas to be modified in any way because the
formulas will all work with the spreadsheet in which they
are being copied into......

Can anyone help, I'm desperate,

Cheers

Anne
 
Anne,

Right click the sheet tab you want to copy, select move or copy,
make sure the other file is open as well check create a copy and
from the drop down select the file where you want it. Or if
you copy to an existing sheet. on the source file select the sheet,
do edit>replace and in the replace what put =, replace with r=,
replace all, now copy all the ranges over and paste them into the new sheet.
then reverse the replace by replacing r= with = on both sheets..
 
Another way is to "Edit Links".

After copying the sheet to the other WB, go to:
<Edit> <Links>
And click the "Change Source" button.

You can then either enter the name of the new WB, or navigate to it in the
window and click < OK> <Close>.

This redirects all the links in the copied sheet to WB that you stipulated
(linked to itself).

If you have formulas linked to more then just one WB, you will see them all
listed in this "Edit Links" window, and you can choose which "set" of links
to redirect to which "other" WB.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi There,

Can anyone help....

I am trying to copy a worksheet with formulas etc from one
xls file to another...

The only thing is, is that when I copy it the formulas
between the files, the formulas in the copied version are
automatically updated to include the reference to the
orgininating spreadsheet file...

All I want to do is copy a worksheet with the formulas etc
from one spreadsheet to a different spreadsheet. I don't
want the formulas to be modified in any way because the
formulas will all work with the spreadsheet in which they
are being copied into......

Can anyone help, I'm desperate,

Cheers

Anne
 
Hi Anne,

Please forgive me I cant seem to find where I post my question, I would
appreciate any direction you may be able to give.

Thanks
Rita

(sad new user)
 
Back
Top