I have a link from an external Excel file displaying data within my
(current) Excel file.
To make sure I am pulling the latest version of the data and
displaying the timestamp of that

I'm using Excel 2003 and have files with lots of links.  Cells are linked to
an external workbook.   The cells in the same column have inconsistent link
results. Some cells display #N/A and some cells are fine.  The formulas are
the same, except they refer to a cell in a ...

I have an excel sheet that has hyperlinks to other sheets. All sheets are on
a network share and permissoins are open to all.
When I attach and email the excel sheet (that contains the hyperlinks) from
the network share, the recipient receives the sheet and opens it, the

I am looking to create a mailto: link in an Excel spread sheet that puts the
date of the form as part of the subject.
eg: Subject: Sales for 7/1/2008
The "Sales for" would always be the same but the date would be taken from

Can you lock a column that your hyperlinks are in so that when the user sorts
the data that column does not sort?

I am trying to copy a hyper link down 300 rows in a document.  I was hoping
as I drag down the cell that it is hyperlinked to would change just as if I
were copying. How can I change the designated cell in the hyperlink without
having to enter it 300 times.

I have a folder with multiple excel reports from different people providing
data from different areas using the same chart format.
there is multiple data sections and dynamic charts in each file.
every month, the data in each chart has to be moved one cell over for the

One of our departments wish to rationalise their directory structures, which
overtime has become a bit of a mess.   They have numerous files across this
existing structure that have links to other files elsewhere in the structure.
Their wish is to move all of these into the new ...