We're using Outlook 2003 / Excel. The refresh data option (DATA / Refresh
Data) use to work fine on my Excel documents. All of a sudden the field is
now
greyed out, and thus can't be selected...

I've created a spread sheet that contains a very long list going across in
columns , dates going down in rows.
For easy data input, I've shaded every second column in yellow.
The problem is, if at some stage, I need to insert a new column,  I end up

I have data validations in sheet1  as named range lists from sheet2.
When I have deleted sheet2 and copy sheet2 from identical other workbook -
my validations does is not work...
I see Name ranges in copied worksheet, but when I use they in validation - I

I have a question, if is this possible:
in worksheet3
copy D27 - D40 in B27 - B40
delete d27 - D40 the cells move left

Dear Experts,
Please consider this & help me to sort this out:
I have a Data Sheet contains 5 col namely: Emp; From; To; #OfDays; LeaveType
I fill these columns on daily-basis using designed VB Form as below

Is there such a thing as fuzzy logic matching in excel?
For example, if I have
Name           Addr1                Addr2          Addr3
Davie           Kings Road        London         England

I have written the following test program which does not work. Does
anyone know why it doesn't? I want to copy a column from one workbook
and paste it into another. I am now getting desperate as this is
holding up work. Here is the code:

I have written a graph analysis macro using VB (Excel 2000 Premium) and
assigned a customized toolbar / icon to the macro.  It runs well, but
it's helpful to rename the file after an analysis is complete under a
more desriptive name.

I want to convert a matrix of results in decimal or real number into a
spectrum of colors (or grey scale if it's not possible) to make a "picture"
it's quiet urgent so a great thanks to who will success the challenge!

Dear friends,
In an excel worksheet, in a cell I am having a day, say for example
03-May-2005 or 03-05-2005, In another cell
I have to increment only the month by 2  i.e from 03-May-2005 to

I want to ask you for a small advice.
What should I do If I want to limit the number of characters/numbers i
the cell.
For instance: I have column named "phone numbers" and I want to inser

I have an HTML data (ex. 17-2 with "-2" in red-colored uppecase)
I want to paste it to MSExcel but it converts "17-2" to calendar dat
(ex. 17.feb). THIS IS NOT NEEDED!
I can fix the cells manually, but it takes too much time.

can anyone help i am currently working on a daily deployment sheet i
which i am trying to make sure that all the associates i am placing i
certain area's are not being deployed to the same area every day.
I was hopeing all i had to do was put a Conditional Format into a cel

In setting up a process flow instruction in Excel, using flowchar
autoshapes to diagram the process, I want to click on any of the flo
chart autoshapes and have a sub document appear on screen (which coul
in turn could have a flow chart on it).  Would also want to web enabl

If i have a series of cells that are alphanumeric (i.e. 43A), is there a
way to format that as a number so that it will show up as '43A' in a
graph?