I need to link pdf files from Excel 2002.  When I try to do this, it flashes
the adobe window but then closes it right away.  The pdf's were created from
word documents and are for viewing only.  I can't convert my excel file to
pdf as I need users to be able to sort the data ...

Is there a possible way LINK a (formula table array) to a cell, that when
updated it shifts that formulated array to corresponding coordinates?
WORKSHEET 1: columns A,B,C,D
9/8/2006        9/15/2006   

XL2003. I've checked Help and this forum, but I am still wondering what these
notes like [$-F800] in front of date custom formats mean? I understand the
other bits but these bits don’t seem to do anything.
[$-809]dd mmmm yyyy and [$-F800]dddd, mmmm dd, yyyy

Is there a way to create a simple "Data Form" in Excel, and then use the VB
Editor to edit it? I'd like to create a form very similar to the Data Form
but need a few changes, but I don't want to create one from scratch.

For the VBA gurus.
I have a data table, 500,000 rows, in XL 2007.
A colleague wants this data put into XL 2000.
My take: write VBA code which splits the 500,000 rows into 10 tabs of 50,000

have 16 columns of income brackets in thousands (1.64=1642 etc) would like to
list these incomes and their respective % in the same cell and do a wrap text
that woud look like information is in two rows but just a little larger row.  
to look like

XP Home
Office 2000
(2) user accounts, both administrative.  
One user account works fine.  When logged in under the other account, Excel

.Hi,
I am trying to use a drop down list and have checked the "ignore blank"
option but it does not ignore the blank cells.  So I did the following to try
and cricumvent it but need some help.

Hi, I'm working with a large worksheet(40 000+ rows).  I would like to allow
the user to make data changes to cells and then only save those changed rows
to a new spreadsheet.  I know Tracking will keep track of the changed cells,
but I want to actually copy the entire row to a ...

I would like to create an active macro, which when you open the file is
autosave only this file every 10 min but don't disturb any other program or
files.
Someone can help me.

I wanted to disable the close button in the upper right hand corner of Excel
so users would have to use a button on the spreadsheet (assigned to a macro)
to close the worksheet. I used the following code:
Private Sub WorkBook_BeforeClose (Cancel As Boolean)

I'm trying to create a sumif statement that pulls data from an external file.
I am also trying to enter the path of the file using the full UNC path. If I
create the formula without entering the UNC and just leave it as the default
file name etc. it works fine. With the UNC path, ...

If you have a column of some random, and some repeating values, how can you
have the sheet return to you which values are in the column.  For example, if
I have a column of 6 values, two values are 39, two values are 45, and two
values are 34, how can I have excel tell me the ...

I wonder is there an easy way, like a keyboard shortcut, that I can
find a closing/matching parenthesis in a long formula?
Thank you.

The "Find" function in Excel 2003 finds what I want sometimes, and on the
next worksheet, it will say "Microsoft Office Excel cannot find the data
you're searching for."  I would like to look through a column of numbers, and
they all start with 0.____, or a negative -0.____(fill ...