Breaking links

Hi Harriet,

Thank you for the forum question.

If it linked between workbooks you can break the links on the DATA tab in the CONNECTIONS group EDIT LINKS.

If it is linked inside the same sheet or workbook you can copy the formulas and paste them in the same range as you copied them and on the PASTE OPTION list click values. Then Excel will paste only the values and break all the links to linked cells, but this will also remove your formulas.

I hope this can help you.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector