Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
verify

ResolvedVersion 2003

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

Thu 21 May 2009: Automatically marked as resolved.

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.