Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / June 2004

Tip: Looking for answers? Try searching our database.

links basics

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mustafa Sapmaz - 11 Jun 2004 12:13 GMT
Dear All,

It is very critical for my business to learn the basics
and the backbone of links in Excel. Are there any
tutorials or articles that gives wealth of information
about MS Excel links? (in Excel 9.0.6)

Web addresses are also welcome.

You can also post to my e-mail above.

Thank you in advance.

Mustafa
wiseman - 12 Jun 2004 11:03 GMT
Mustafa,
It is something which I have not found much about on the web.  Partly
because it is so easy once you are shown, by far the best way is to ask
someone who can actually show you as you work.

All formulae can work equally well with cells from the worksheet where the
formula is, another worksheet in the same workbook, or another workbook.

There is a bit here on links
http://www.tutorialbox.com/tutors/off2000/excel/functions.html

You can practise by building a little formulae.

Have a workbook with 2 or more worksheets.
press "=" then click on an other worksheet, put your cursor on a cell in
this workbook, press return.
You now have a cell linked to another workbook.

Have 2 or more workbooks open.
press "=" then choose window from the menu, click on another workbook name
to go to it.
Put your cursor on any cell in that workbook, press return.
You now have a formula linked to another workbook.

Note in the first example the formula is relative by default, and in the 2nd
it is absolute, see the link for explanations of these terms.

When you build any formula, however complicated you can switch to another
workbook or worksheet and reference a cell in them.

If you have a specific requirement for linking post back with details, it is
difficult to give advise with such a general request.

> Dear All,
>
[quoted text clipped - 10 lines]
>
> Mustafa
wiseman - 12 Jun 2004 11:11 GMT
Also search for "About using formulas to calculate values on other
worksheets and workbooks" in the excel help.  If you can not find it I could
paste the page in another post.
Barbara

> Mustafa,
> It is something which I have not found much about on the web.  Partly
[quoted text clipped - 43 lines]
> >
> > Mustafa
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.