Copy/Paste


D

Dominic Vella

I'm trying to copy formula's from one excel workbook sheet to another
workbook but whether I do a special paste value, or special paste formula,I
still end up with a link. Mind you, the sheet I'm copying does refer to
other sheets in the workbook.

Eg, book one has sheet called "totals", in it has a link to a sheet called
"Station1".
Book two already has a sheet called "Station1". When I copy the book 1
"totals" sheet into book 2, I want the pasted information to reference
books.Station1 sheet.

Can someone explain how I can do just a straight paste without it referring
back to book1?

Tnx
 
Ad

Advertisements

D

Dave Peterson

I think your choices are to do the copy|paste, then go back to fix the link.

Edit|Links|change source

or (what I like):

Select all the cells on the original worksheet.
Change all the formulas to text.
Edit|replace
what: =
with: $$$$$=
replace all

Now when you copy|paste, there are no formulas to adjust. Just plain old text.

Then after you've pasted, you can change the text back to formulas:
Edit|replace
what: $$$$$=
with: =
replace all

Remember to do it in the original workbook, too--or close that without saving.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top