Excel

Hi Jack

Thank you for your question regarding the linking of cells.

The best way to refer you linked cells to the new source data is to:

- open up the linked workbook
- Open the 'Data' tab (on the Ribbon, top of the interface)
- within the 'Connections' group, click 'Edit Links'

Here you will be able to see where all your linked formulas are referring to & if there are any errors.

To change the pathway of the source data highlight the relevant 'source' and click 'Change Source' (right hand side). From here navigate through to the new worksheet location.


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer