I have Workbook A which has demographic information for 1,000 Clients.
I have created Workbook B which will link to the information in
Workbook A. Some of the columns is a carbon copy of Workbook A. I
don't want to do a copy and paste everytime, so I have used external

I have written a spreadsheet using Excel 97 and have made
use of hyperlinks to various Word documents and other
Excel sheets. However, whenever I open the link, the
original spreadsheet closes. The only way I can get the

I have a number of databases stored on Excel Workbooks and I want to create
another workbook to get information from those databases. I will make
reference to a number of the databases with the following:
COUNTIF("worksheet name followed by filename", "=blablabla")

My application consists of several workbooks all open at the same time.
I would like to store a Logo in "MySetup.xls" on Sheet1
In another workbook I would like to have the Logo appear via a link, so if
the logo changes I only have to change it in one place.

Hi All.......
I have a sheet with over 800 Hyperlinks to external AutoCAD files.  All are
in a  single column, all work fine and all  link to the same directory, but
now I wish to change the paths to another directory.  It's easy to change

I read the microsoft macro for breaking the chart link at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213443&
===
Sub BreakChartLinks()

Are there any Third Party utilities which can automatically (or with
some user interaction) change the links of other Office documents
within Excel spreadsheets ?
Many thanks

I have 12 sheets in a workbook. (1 for each month). All are identical except
for the month and the actual data within the cells, but the layout is the
same.
Is there I way I can make all the subsequent months inherit the formatting