On a spreadsheet a college has created, which contains links to another
excel file, cells that are pointing to null values in the remote file
are all showing #REF! when the remote file is not available. In my own
tests, keeping Zero Values, Update Remote References, and Save ...

I am trying to mail merge in word using excel spreadsheet
as data fields. Trouble is what appears in s sheet
doesn't appear in word e.g. in s sheet may be 3.90 - in
word becomes 3.8999999991 and 3.60 becomes 3.6. Have

Created a file in Office 2003, but has to roll back
system to 2002 to correct a networkingb problem.  Opened
the file inn Excel 2002 and got 'compile error in
DistMon'.  When I re-upgraded to Excel 2003, get same

I have a workbook whose data in columns on sheet1 (Year) need copied and
linked to rows on other sheets (Jan, Feb, Mar, etc.), and need updated when
the data on the Year sheet is updated.  I have done this with January by
editing the cell references manually, but when I tried ...

Window into Excel results in text rather than a hyperlink. I've been
searching for an answer all morning, and I'm sure it's something that I'm
being duh about. Any help is greatly appreciated.

I'm supporting an application using Excel 97/VBA that
needs to consolidate totals from corresponding cells in
many different workbooks into another workbook. The
technique being used in code is to cycle through the

Ok If I have excell file open with 6 tabs
4 are used can I make the 5 and 6 tab
load another excell file on those 2 tabs
I use a few file togather and want to

On opening my workbook, I receive the message: "The workbook you opened
contains automatic links to information in another workbook. Do you want to
..."
I have one workbook with several worksheets (27 in total).

I doing a mass mailing address on #10 envelops. I am
linking this to a excel spreadsheet with 3000+ records.
How can i setup so the corresponding zip barcode shows when
the mail merge is completed to printer?

-----------------------------------------------------------
---------------------
I have been given the task of creating a web survey form.
The form itself is going to be quite basic with name etc

Here's the problem.
I have 10 clubs.
I receive 120 spreadsheets per week which is 12 each for
10 clubs.

Is Excel 2003 any better than Excel XP at handling
worksheets that have multiple links to multiple
workbooks?
Any help is appreciated