copy sheet1 from bookA to bookB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I copy a sheet with formulas from bookA to bookb, all formulas than point from bookB to bookA
How could I avoid that
Same for copy sheet1 to sheet2
Thanks Manfred
 
Once you have copied the sheet across and the formulas
are referring to bookA...

Eg. ='[BookA]sheet1'!A1+'[BookA]sheet1'!A2

Highlight the entire new sheet, and do a replace (Ctrl H)
Find What : [BookA]
Replace With :
Leave Replace With blank and hit replace all.
Obviously you need to have a sheet called sheet1 in your
new workbook.

Check you have broken all links by going Edit / Links...
links should be greyed out. Sometime they remain if you
have copied named ranges from a previous workbook.

Hope this helps.
Paddy
-----Original Message-----
If I copy a sheet with formulas from bookA to bookb, all
Click to expand...
formulas than point from bookB to bookA.
 
You must log in or register to reply here.

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

Similar Threads

vlookup multiple variables 1
Break Links not working !!!! HELP !! 3
Creating data cell from other table from diff. Workbook 1
Creating separate files from multiple sheets 1
Cell Selection Bug!! 1
Create seprate files from multiple sheets in excel 4
function how to! 6
Regarding IF function or vLOOKUP function 2

Back
Top