I have to make a change to some data being collected in preparation for
a web app that I am preparing to write.
I need to have a half-dozen users open up a spreadsheet and list
customer numbers & names, PO's and a user code to a single sheet inside

When I open Excel nine filenames appear on the RHS as 'recently
used files' (this number was set via Tools/Options/General, of
course).  In the middle of this list are 3 no-longer-used files.
Though the files themselves have been deleted their names remain in

I'm very unfamiliar with Excel, so navigating within it is a struggle for me.
My boss has created a job tracking system in Excel, with multiple tabs
across the bottom, one for each worker in our group.  Several times a day I
need to find out who is working on a particular job, ...

I am trying to format numbers in the General catagory but Excel  puts a
decimal in the number and I cannot remove it; I have tried using the General
and Number formatting fields but nothing is working, I just want to type in
the year and or a general number..thats all

I'm trying to change the font on my comments, but it doesn't work.
I'm doing the following:
1. Right click on cell with comment
2. Modify comment

I'm a 68 year old retiree and a basic user of Excel. I can do various
simple tasks, but arrays and complex formulae allude me. Also I don't
know the various names of functions, so I can't use the Help to look up
what I want. This looks like it could be a very simple formula or ...

I use the statement =IF(COUNTIF(Area1!$B$2:$B$7,A4)>=1,"",ROW()). How
is this statement if the condition not only applies for the area in
Area1, but also in Area2 to have the value ""?
So, it is like COUNTIF Area1 OR Area2 True, False

How can I add, say 12 weeks, to a date to arrive at a date at the end of week 12.
Thanks in advace
SJ

Just got RTM excel 2007.
Looks like there is no way to enable macros on a xslm file if it has a
password on it.
To recreate:

How do I get a cell with a hyperlink to a webpage to pass through a VLOOKUP
formula?
I'm running office 2000. in one sheet I have data in which one column
contains cells with hyperlink to WebPages.

I have created a list via Insert > Name > Define.
On a list of cells I want to let the user choose a value from the
defined list. Is it possible to shorten the list when a value is
already choosen at another cell?

Hello Excellers,
How can i assign a valua (text) that is in cel B2 of an active sheet to a
part of the message of a MsgBox ?
Thanks for your attention,

We have created a workbook to track Work Orders for repairs on equipment to
our customers in a four state region.  One worksheet is used to enter the
workorders, row by row, starting in column A out to AA.  Column A has work
order number (very simple – 1,2,3,etc).  Column B is ...

I have the following problem, i Need to find te latest date in a row.
the format of the date is like 10-06 and for example 11-'06.
Because of the " ' " in the last date, the max function returns 0 as
value.

Everything work good but after closing the Excel I got the message:
"Excel ecountered an error and must to close ......" ,so you must say do not
reset Excel and do not send report what is to much job for closing the
program!