I have the file path to several files of mine in columb A.
In columb B, I use =hyperlink(A1) and copy down.
The hyperlinks work fine but I only want to display the actual file
name.

I've tried deleting links via the Links Dialogue and the Defined Names
windows and I 've tried using code to delete the names.  But my code returns
an error message stating "That name is not valid".  It is referring to a
defined name such as

I now use Excel 2003. BAck in Excel 2000 there was an add-in "Access Links"
which allowed conversion of Excel Listfile data to an Access table. I cant
find an equivalent in 2003. I know I can import into Access ( that is "pull"
the data into a table) but it's more important for ...

I am having a problem linking one workbook to another. Let me lay it
out...
I ahve a database that runs a query and then uses a macro to "Output
to" the query results to a excel file called CARQuery.xls. Once that is

I am working on 2 Excel files with multiple tabs and spreadsheets going out
to Col. EU. I don't have any problem when I am working on these files at my
home computer but then when I email them to others, the links are still
attached to my computer and therefore, it appears, cannot ...

I created an excell file, and I am refreshing the excell queries using
ActiveWorkbook.RefreshAll function, but everytime I need to enter the
username and password, is there a way to avoid enter the username and
password for each refreshed query, or just enter one time only??

I have the following Macro (which I need to run on approximately 200
different workbooks) -- what is the BEST way to achieve this?  Should I use
a Function (and if so, what would it look like)?
NOTE:  I'm assuming that this Macro should reside in a Module -- but, should

I am trying to look up a reference value in a excel worksheet cell in an
access database to display, in excel, a value related to that reference.
i.e. enter a part number in a excel cell (reference). I want it to lookup
that part number in an access database query and to display ...

I need to link or embed the value of a single cell in excel into an html
email in an outlook public folder.
The value of the cell contents will change weekly and the email will need to
reflect this.

Does anyone know how I can resolve this issue ...  I have a directory which
contains 129 worksheets which have links to external data (in a Master
Spreadsheet) -- I need to copy these files into a New Directory, but kee the
Master Spreadsheet (which they are linked to) in the ...

I suspect that (since I didn't get any response on my previous request for
assistance) I may need to approach this in stages ...
Assuming that Information Rights Management (IRM) won't give me the detailed
permissions I need, basically, here's what I need:

Here is a scenario.  I have a folder which I am going to use various forms
from we will call this the template folder.
I have an excel file called information.xls
I have a word file called work.doc

I have an Excel (Excel 2000 SP3) file (2 Mbytes) with about one thousand
hyperlinks to word document or excel document. This Excel file is situated
on a machine on our network.
- When I open this Excel file from this machine : it takes about 5 minutes

Haven't been able to find info on this problem anywhere. Formulas in my
spreadsheets that link to other spreadsheets are, unbidden, changing to
reference the startup directory (c:\Documents and
Settings\username\Application Data\ Microsoft\Excel\XLSTART) INSTEAD of

Excel 10 SP3, WIN XP Prof. 5.1 SP1
When I go to "Edit" => "Links" => "Startup Pompt" I can select
"Don't display the alert and update links".
But the alert is always displayed when I start a file with such a