Jack has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel
Hi there,
I have a workbook with several sheets linking to each other but somehow the file was infected with a virus. As a solution I have copied the worksheets over to new workbook.
The problem is that the formulas are still linking to the old infected workbook and not the new one, is there a way to change all cells with formulas rather than going through the relevant cells?
thanks
Jack
RE: 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
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
