------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.yourdomain.com.au/showthread.php?t=206693

In the Links menu is possible to know all workbooks on wich the active
workbook depends on. Is it possible to know all the workbooks that depends on
the active workbook, the opposite thing?

I have a workbook with 2 sheets.
Each sheet has cells linked to data in 2 other separate workbooks.
I do not want the links to update automatically.
When I go to "EDIT" - "LINKS" the "Manual" radio button is grayed out.

I posted this is the normal excel group with no response, so here we go.
I've looked and played with all the settings that I think would allow
automatic refresh of external data, but I still get a dialog box every time
I open the workbook that asks if I really want to enable or ...

Dear
I want to make referene from from sheet to another in non-contigous cells
( like.A11, A21,A31,A41,....)
When I drage the cell, it just refrence contigous cells ( like

I get this message when trying to update links in certain files (2002
version)...
Warning: Open source to update values   Click Open Source. The link cannot
be updated until the source is open.

Dear
I Wannt to make the excel sheet only calculate one cell that I put a rule in
it.
Also, can I make the Excel refresh automatically every certain period of

is there a way to write a
statement in Excel (like an IF Statement), that would display a
specific picture if a certain #/word/etc is typed in a cell?  For
example in A1 if I typed in ball, it would automatically bring up a pic