I cannot open the Options menu in Excel 97. I get an error message and then
Excel quits.
I am running Excel 97 on Windows XP sp2.
I tried reinstalling Excel. That didn't fix the problem.

In a sum total column, how do I add more than one row at a time?

I have a very basic table/database (columns of data with a field name in the
first row) on a sheet in one tab.  How can I have other tabs which
dynamically show only data that matches certain criteria in the database?  
For example, my database has columns for the Project Name, ...

I have never for the life of me understood why Excel's Tools / Options
is completely disabled if no sheet is open.
To my mind, Microsoft has never implemented a distinction between
options applying to the current sheet, versus those applying to all

Every time I upgrade to a new version of MS software, I get these
stupid new behaviors shoved down my throat.
Now, dont' get me wrong. New behavior is fine--provided it's turned
OFF by default, not ON.

I have a work sheet with data in columns B and C. I am wondering if there is
an automated way in which I can search for a certain value in Column B and
based upon that field change the data in Column C? As in the sample below
Column C data is not the same for the data listed in ...

For the record the machine is running WindowsXP, and Office 2003 with
all recent updates from Windows/Office Update. There have been no
'weird' tweaks applied to the machine, and it is a straight install
with the 'Full Install' option in Office.

Is it possible to format a cell to stay like it: ( -10% )?
With this format (0%), the excel shows this - (10%)
Thanks a lot!!!
André.

Hi, I need a formula to achieve a average for some mutual funds I have
purchased over a period of years.
Column A contains the number of shares I have purchased and Column C contain
the price per share and Column D contains the cost for these shares.  For

I have a workbook consisting of multiple sheets.
Each sheet, a part from the first, contains data about an experiment
that has been run.
The first sheet is a summary sheet (set out as a table) with

How do I tell Excel to only add amounts in column C if they have been
flagged with an "X" in the adjacent column B?
TIA

Does anyone have any spreadsheet suggestions that can be used for
monitoring tasks in excel?
I am looking for something that will flag when tasks are due etc
conditional formatting etc

I have a column containing dates, (European date format)
01-05-2006
07-09-2006
01-12-2007

I have been using Macro Recording as a means of creating and understanding
macros.
Now when I want to add a function to a macro I record a separate macro, then
edit it into my existing macro.

When I import an xml file to excel 2003 or 2007, they both asked the
following questions:
1. the specified xml source does not refer to a schema. Excel will
create a schema based on the xml source data. I click OK