i have an excel 2000 workbook that when you try to open it it says it i
corrupt ..
the fix i got was to  go to file, open  from the drop down menu on th
open button ,select open and repair. I can only see,  open , open rea

when i try to open a excel 2000 worksheet it says that the file i
corrupt .Is there anyway i can still open it
--
Message posted from http://www.ExcelForum.com

Can any one help me to work out a formulae to do the following
1.I have  $100,000 for my retirement pension.
2. If my investments have an effective earning rate of 6% per annum ,paid quartely
3. My draw down from my fund is say 8% per annum , paid quarterly

I have "DECEMBER 10-12" in a cell, it has some type of comment
indicator in left top corner which is a green triangle.
How do I hide these? or make them inoperable?

I have a simple spreadsheet for calculating students' grades.
Each class, assignment, or test has a point value (not a percentage).
Example:
A class is worth 20 points

Let me try and explain what Im trying to do.
I have a spreadsheet for ordering parts for photocopiers.
Then I have individual worksheets with the parts for each model copier.
What I want to be able to do is on the main sheet, set it up in the

I'm trying to discover if it is possible to do several things in Excel 2000.
I have set up an accounting system.  There are 13 .xls files.  One for each
month, and a Year end Summary.  The file for each month is made up of 8
separate worksheets for accounting purposes.

I have my VLookup happening
querying an array of 25,000 records.
I want to beef it up to 150,000
Can VLookup query across 3 sheets of the workbook?

I am trying to open the purchase order template in Excel
2000 and I get this error message: "This workbook contains
a type of macro (Microsoft Excel version 4.0 macro) that
cannot be disabled nor signed.  Therefore, this workbook

I am trying to build a workbook that summarises data out of other
workbooks. This shows a month by month break down, however, some of the
files are not created yet, but I would like it to show the values as
soon as that file is created. When I fill in the formulas to link to

I have Excel 2003 installed on three computers.  On only one I get a the
dialog: "This application is about to initialize ActiveX controls that mught
be unsafe..." every time I open an excel document.  On the other two
computers I do not get the dialog.

Hi, I have columns that I tried to change the cell information t
another cell that have to be the blank for a row that contains directo
name in cell A and for the movie titles I have to have director name
instead of the titles.I  totally lost, please help me, the data in cel

I have an excel database with over 4,000 records. Each month, I have
to run 100 reports based on this data. Currently, I am using multiple
DCount Formula to filter the data. My problem is I to manulaly update
one of the Dcount Criteria fields before I print the report.

Hi - I'm looking for a function that will look at a cell (containing
text) in one column and then look to a range of cells in another column
and if a match is found to indicate "1" if not found to indate "0"
***** Posted via: http://www.ozgrid.com

Is there any way to delete empty rows within a two column list?
I have about 4200 rows with blank rows inserted randomly that I need t
delete and move the row up
--