I am looking to add a conditional sum to a workbook.  The trick is
that the information that i want to sum is another workbook.  Is this
possible or do i need to write some code in VBA?
Thanks,

I have a workbook in which the creator changed color pallete. Every time I
open that workbook, colors in other workbooks change immediatly. How can I
stop it happenning?

Why is the name that I gave my excel workbook not showing up in the title
bar when i open the workbook? It use to always show up there, but now when I
open a previously saved workbook, there is no name in the title bar.

I have the following:
Col #1       Col #2       Col #3
  Z1              ZA             ZM
  Z2              ZB             ZN

I've a workbook with hard coded formulas without VBA code. Which includes
Groups & outlines, name ranges, conditional formats and functions like if,
sumif, indirect, arrays, etc., for each change in a single cell taking too
much of time for recalculating the workbook. And also ...

Hi, I have a spreadsheet which had informaton on it, i went to access it just
now and the file is still there but NONE of the data is on it. How do I
recover the file to the last time it was amended?
Please dont tell me its gone forever

Is there a function that allows you to select all cells that have a certain
format (for example, all cells that are highlighted yellow)?

I have a long Excel document that my peers would like to print on fewer
pages. Because I am printing the document on fewer pages, Excel has
compensated by shrinking the text when it is printed. So now the document has
14 pt font when viewed on the computer but when it prints out, ...

I suspect this is a simple question for Excel 2003...
I need to take the highest 5 of 7 cells in a SUM function, or more to be
more concise, drop the two lowest cells and add the the top five.
I've been trying to SUMIF but I can't seem to get my criteria correct. I'll

I've got to concatenate 416 cells within a row, the resulting text also needs
to be split by commas .  do i have to manually write out
CONCATENATE(A1,CHAR(44),B1,CHAR(44),C1... etc or is there a way of speeding
this up?

I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.

I have a range that keeps changing and I need to count how many are in
this range.  I copy and past information from one workbook to
another.  I delete rows that are not needed and then I need a count of
how many rows are left.  Any help would be greatly appreciated.

I would like to turn on my enable live preview but unfortunately I am un able
to select it because it's grayed out.  Any Ideas on how I can enable this
feature.

I have a column of about 1000 dates in Excel 2000, all of them entered in
text format..
All the dates are different and written as in the following example:
20Feb1950

I have an order log which is added to on a daily basis.
I have made a pivot table from this to show ordering by divisions, suppliers
etc.
However, when I add new orders to the log, the pivot table does not update.