Corrine has attended:
Excel Intermediate course
Verify
How do you verify that a worksheet is linked to a workbook?
RE: Verify
Hello Corrine
Thank you for your question and welcome to the forum.
If the file workbook that is linked to is closed, you will find that when you display the formulas in the spreadsheet, you will see that cells with the links in them will display the name of the file, sheet and cell that they are linked to.
To display formulas use Ctrl + 'pipe' key (the key directly below Esc key on your keyboard).
Alternatively if you go to Edit - Links, a list of the files that your spreadsheet has links to will be displayed.
Kind regards
Amanda