I finally resolved the problem I had opeing a file. In the "Name Conflict"
box, it says, "name cannot be the same as a built-in name". Then it gave me
the "old name" and a box to enter the "new name". The old name was
"Print_Titles", after trying every name under the sun, I ...

I have a macro in Microsoft Excel listed below.  I need for it to repeat
until xxx is entered.  Any help will be appreciated.
Sub OptionExplicit()
'

I have huge sheet with thousands of non-standard lines of text.  Some of the
lines have the following line in a cell:
ProjID=MFG-Company-DA-33 ProjType=BBAA Uplift=0 CostType=Time Mgr=Smith
I would like to understand how to write the VBA that will skip the lines

I am trying to use a sumproduct function to return how many M&A deals were
over a billion dollars in a given year. I've been trying
=SUMPRODUCT(($A$18:$A$3295=$C4)*($D$18:$D$3295>=1000))
C4-represents a year. The sheet is set up as follows:

I'm trying to produce the following graph
Program Name    Long    Leverage Gross
M1                   23.06%    80.00%
M2                   23.86%    96.67%

I've created a worksheet for our group to use.  However, one of our members
has quattro pro.  Is there any way to convert to a format that she can use
without losing my formulas and such?  Thanks.

Excel 2003 - SP2
I have a spreadsheet given to me by a co-worker.
Example:
A1                 B1

Sorry for the vague subject line but I couldn't think how to summarise this
problem in a few words.
I've created a workbook to record how many hours I spend working on various
projects. The workbook consists of a sheet for every week of the year and a

I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't
ask, its a favour for someone) Which works fine, until I save and re-open the
excel file. It appears to be because excel shortens the path and therefore
breaks the link.

How do you delete saved items from under recent Documents
when you save as it keeps on recent documents
how do you delete them
Thanks

To define a payroll bi-weekly payperiod.   ie.    02/24/08 - 03/08/08
Want to enter one date in cell C4.     say    03/14/08
I know that the formula   =C4-19 will get the start date  02/24/08.
I know that the formula   =C4-6 will get the ending date  03/08/08.

I am using Excel 2000. I have created a 100% stacked column graph. I want to
display the percentages on the face of the columns themselves. When I format
the data series and go to data labels the show percent is greyed out.
Probably because % is already shown on the Y axis. ...

I am trying to create work instructions that can easily be modified. I want
to link a cell to a word in the middle of the sentence. I have a table with
the list of parts and tools, instead of using item 1, 2 ... in the sentence I
would like to be able to link a word in the middle ...

I am having some sort of mental block.  I'm pretty sure there is a simple
answer to my problem, I'm just not seeing it.
OK, I have a spreadsheet that is 49 columns wide.  (ouch)  However, all this
data must be tracked.  I do not have Access to simplify the issue.

I've lost the color highlights that show which cells my total refenences when
I double click on the total, anyone know how to get them back?