Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Verify
Resolved · Low Priority · Version 2003
Corrine has attended:
Excel Intermediate course
How do you verify that a worksheet is linked to a workbook?
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:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.11 secs.
