Excel Question - How to remove external links

[mdrollas]

Hi,

I did copy & paste on a few worksheets and noticed that the formulas didnt get copied correctly, instead they now have external links.

e.g. [1st workbook]address database'!A20)

Instead I am looking for it to reference the same sheet in the current workbook 'address database'!A20)

I have about 20 worksheets so doing it manually is pretty much impossible. I did research on google before posting.. so please dont flame.

Thanks so much!

 

[mayest]

You need to do a Find and Replace on the workbook name in the formulas. Find [NameOfWorkbook.xls] and replace with nothing (leave blank). You could break the links by going to Edit --> Links, but that will just leave you with the number, which isn't what you want.

 

[mdrollas]

mayest, thank you for your reply. I tried that and the formula is corrected, however the value becomes 0.

I am wondering if its a circular reference error since when I open on this particular excel file it displays a circular reference warning. Thanks!

 

[mdrollas]

Problem solved, thanks!