RE: Merging spreadsheets
Hi Marcus
Thank you for your question. If your workbook contains links to other spreadsheets you can find details of those links by going to Edit > Links. The dialogue box that appears allows you to update and change links if necessary. It will also allow you to open the source files.
I hope this helps - do let us know if you have any other questions.
Kind regards,
Andrew