I have copy and pasted some spreadsheets across from (file
1) into another file (File 2). There are some formulas in
these copied spreadsheets (now in file 1 and 2)that link
to other spreadsheets within file 1 and these spreadsheets

I need to link to a worksheet in another spreadsheet
using  a cell to define the work sheet
eg
='[RBM Sept 04.xls]"a1"'!B46 - where "a1" is the cell with

Excel crashes when I open it in excel 97 or 2000 it opens
fine in 2002. In 97 or 2000 I get as far as this workbook
contains links do you want to open them if I select yes or
no it crashes. It was created in excel 2002 and opens fine

How can I program a radio button or a check box to automatically print a
linked document.
In other words, if the radio button is selected, and I print the Excel
spreadsheet, I want it to automatically print the file that it is linked to.

I am having difficultly automating hyperlink insertion into a
spreadsheet. I need the value of the individual cell to be
incorporated
into associated the hyperlink.

I need help.
I have an Excel file that is 35MB in size. This file is link to
another Excel file that is 19MB in size to get its data from. When I
tried to load the file to Excel 2003, it asked me if I want to update

I have an ONLINE  PDF file that contains various chapters and sections
(numerical headers, "23.1, 23.2, etc).
I want to be able to open the spreadsheet and insert a link to specific
chapters within the PDF file and have the Acrobat Reader then display them.

I have an Excel Worklbook consisting of multiple sheets. Can I convert all
those sheets in one shot using Adobe Acrobat? If not, is there any
freeware/shareware available to do it for me?
thanks,

When I open a particlar workbook the message below comes
up.
"This workbook contains one or more links that cannot be
updated.

I'm trying to automate a few actions whilst loading an excel spreadsheet
1.  prevent the save command from showing from startup.
2. prevent the save icon from showing from startup.
3. when (eventually) exiting preventing if not pressed saveAs, the option

I have imported a Excel Worksheet into another excel file.
I have then link the "Data" sheet to various other calculated sheets in this
Excel file.
The data is mostly text. In some columns the data is displayed as it is

Could someone please help me with the following?  I'm trying to come up with
a formula that will total specific cells if certain conditions exist.
For example:
Column D = Account No.

a while ago MVP Bill Manville wrote a highly useful add-in called
findlinks.xla which found links to external worksheets in Excel
workbooks and optionally replaced them with values.
Due to a recent crash and reformat I went to download it again, only

We have several spreadsheets that all have multiple links
to other documents on different shares.  These shares will
be moving to a different server in a couple of weeks and
we are a bit concerned about what is going to happen to

I'm in the process of Building a new Data Server and will be migrating data
from the old server to the new server.  This will result in the Excel
spreadsheets' links being incorrect.
Is there anyway of checking spreadsheets for links and updating them without