Can anyone explain to me why my spreadsheet sorts as follows. The cells are
formatted as text. This also happens with other similar data but I just cannot
see why. This does not seem to be either a test or numeric sort. In any
collating sequence I would expect all the T10's to be ...

Cheap Haurex Caimano Watches Watches - Haurex Caimano Watches Watch
Cheapest
Watches Home : http://www.watchesprice.net/
Haurex Brands : http://www.watchesprice.net/Haurex-Watches.html

I tried to highlight a column and use the Find/Replace to find "FAIL"
in the column and replace with "FAIL" in bold and red.  It reformatted
the entire cell contents, rather than just the single word.  Is there
a way to restrict the Replace action to just what is in the Find or

I have a music database when opened in Excel in has all info in rows and I
would like to add a few columns.
Want to Add       Col 1        Col 2            Col 3
Example: Row 1 America - 06/03/2007 - America - Here & Now [Disc 1]

I am trying to get information from an excel doc that is closed, copy
it, and paste it into the excel doc that i am working with.  This is
what i have and it seems to work until i hit the final step when i get
an error message saying "Object doesn't support this porperty or

Good Day:
I am using Excel 2002 SP3 and this will tip my hand and show how little I
know about the program.  I'm having a problem with charting.  I have a data
sheet tied to a chart.  The data sheet has all dates from 12-31-2007 through

I was wondering if it is possible to write a macro for the following
situation and if so how?
Basically we have 2 tables with various formulas in its cells, each table
yields different results based on the formulas. Outside of the tables we have

I am pretty new to formulas and such and don't have a very good understanding
of them.  Here is what I am trying to do.
I have two Excel worksheets.  Both files have a column in common, but one
worksheet doesn't contain a complete list of the same information that

i want to print a report of 10 page. i want subtotal on every page while
printing like page 1 of 10 2 of 10

Problem:
In Excel 2007 an xls workbook takes 2-4 seconds to recalculte whenever a
cell is changed. The workbook works fine in Excel 2003.
No external links

I have a worksheet to which I'm trying to associate data in cells on
other sheets.
The data is being put into cells A5-A10, B5-B10 though to I 10 in the
end - that's 54 cells on 27 sheets to populate the D column in this

I have the following formula,
=IF(G5=2000,(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$E$6:$E$10000=G5)*-1,Detail!$O$6:$O$10000)),IF(OR(E5=6,E5=21),(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$G$6:$G$10000=G5),Detail!$O$6:$O$10000)),SUMPRODUCT((Detail!$A$6 ...

I have placed numerous clipart images on a worksheet.  When I define the
print area and then scale it upward by 130 percent to fill a page, the
clipart images are all shifted downward by about one-tenth of an inch.  This
shows up on the print preview as well as the printed page.  ...

While I'm not new to Excel, I am new to using conditional formatting,
functions and macros within Excel. I'm working on a sheet that tracks certain
data on new hires. We track this data for 3 consecutive 30 day periods. I
want to create two macros that will make things easier for ...

The list of recently opened files appears to retain paths to files that
no longer exist on the system. Is there any way to change this, or to
remove files that no longer exist?