We are a group trying to work inserting different areas of information into a
20 sheet workbook with macros.  In an effort to allow all to work at once, we
made four working copies of the master workbook for each to work on.  The
idea was, each would work on a different page, ...

I have an Excel workbook that has links to a workbook in
another folder. I have placed a hyperlink to my Excel file
in a word document. If i click this hyperlink however i
always get File Not Found and have to locate it each time.

I spent a lot of time formatting a page to be just the way I wanted it.  Then
when I went to set up the hyperlinks to the data pages, the cell formatting
goes away, font size etc...
Is there a way to hyperlink without losing your formatting.  I don't want to

We made 4 working copies of a master workbook with 20 or so worksheets and
some macros.  The plan was to have 4 people working on different worksheets,
copy their sheet to the master, resave the master both as the master and a
new working copy.  We were very careful not to have ...

Is it possible in a hyperlink, to make it first copy a file to a new location
and then open the new copy?

How do i reference a specific worksheet in an excel workbook in a hyper link.
(when i follow the  link it brings up the specified worksheet in the
workbook).
What is the syntax for the hyper link that references a specifc worksheet ?

I have one master workbook and several (children) others from where the
master grabs the info.  I have created formulas in the master workbook to
link numbers from the children.  The info from the child workbook are @sum
formulas.  I made sure that even when you insert rows in ...

Does someone has a solution for the next problem
My worksheet is put in R1C1  mode
and I am working with a Database on  worksheet  ("Database")
I have made  a selection of the unique values  in Column 11 in ("Database")

How do I change a link location?
Thank you in advance.
K.S.

Excel (2003) is offering a confirmation dialog whenever an
url pointing to an MP3 file is clicked?
Can this be (easily) disabled?
...or what is an approach to it for files on one's own hard drive.

I need to search for all xls files in a folder, in each of them I need
to search the links that point to a specified server and replace them
for links to another server.
Is it possible using vbscript?

Is there any way possible that I can put three separate
Excel spreadsheets on three separate computers and if one
makes a change on any one of the spreadsheets and saves
it, that it replicates on the other two. The same changes

We would like to move files from one file server to another. Understand all
the links in Excel will be lost. How do we automatically recreate all the
links for all the worksheets from file server A in file server B.
Reason being there are lots of files with lots of links and there ...

We have a file that is generatd by wonderware active factory.  The file has
always been able to be read by clicking "do not update links" by other users
so they can just read the numbers off of the file.  Since the upgrade to
EXCEL 2003 we cannot break the link while keeping the ...

I am using Excel 2002 and I created a link to a SQL server database by
selecting:
Data->Import External Data->New Database Query
from the menu.