microsoft excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel

Microsoft Excel

resolvedResolved · Low Priority · Version 2003

Nicky has attended:
Excel Intermediate course

Microsoft Excel

How do I make sure my workbooks are linking correctly?

RE: Microsoft Excel

Hi Nicky

In your workbook you can go to the Edit menu. Almost at the bottom of the page you will find a Links option. If your workbook doesn't have external links then this option will be grey. If you do have links to other workbooks then the option will be selectable. Choosing Links opens a dialog box that lets you review the links in your workbook, change, update, break and also open linked files.

I hope this helps - let us know if you have any further questions.

Kind regards,
Andrew

RE: Microsoft Excel

Hi Nicky

In your workbook you can go to the Edit menu. Almost at the bottom of the page you will find a Links option. If your workbook doesn't have external links then this option will be grey. If you do have links to other workbooks then the option will be selectable. Choosing Links opens a dialog box that lets you review the links in your workbook, change, update, break and also open linked files.

I hope this helps - let us know if you have any further questions.

Kind regards,
Andrew

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips


Server loaded in 0.09 secs.