links

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

i have a work book linked to another workbook each time i insert or delete a
line i have to reset all the links is there a way you can 'freeze' the links
 
What do you mean by 'freeze'? If you do not want to link to the other file
anymore, then copy the whole sheet and choose EDIT|PASTE SPECIAL|VALUES to
convert all links and formulas to the numbers they represent.
 
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

How to create absolue path link to another workbook (Excel 2003) 1
External Referance over Network 1
Stop linked cells from changing when insert new row? 1
linking to several workbooks in Excel 1
Links 1
how can i protect edit links ? 1
Update links 1
Links error when insert line/row to source workbook 1

Back
Top