Please bear with me for a bit of background info:  We are a manufacturing
company. Our parent company is yanking our AS400. Most of our data is going
into an Oracle system that will hold ONLY data about finished
products/orders. Products/orders STILL UNDER PRODUCTION will not use ...

I want to work on my i12 investments.  However everytime I do so I need to
use 12 diferent pass words. Is there a way to have them all in one folder
where I can place all my files who also have their onw names and numbers. Pls
indicate how can this be done. Some one suggested the ...

My sailing club is in difficulty with people who pay late fees, I am a novice
with excel
and want to automate sending out letters to remind people to pay. Is there a
way to do this or an add in someone has developed that can be adjusted to

Every time I create a graph as a new sheet, it is a landscape graph,
and I am not able to modify the graph area dimensions.
Can I create a *portrait* graph, or modify the area of a landscape
graph to tranform it to a portrait graph?

the Max() function will allow me to capture the maximum value in a
column of data.
Is there a similar function for text?  Example:  I have Projects Status
file that contains varioius data about the project and a color code to

I have a file, that is +- 200MB in size, and has +- 150 worksheets with 700
lines of formulaes in each worksheet.
Problem is that when I update the one sheet where the lookup is, it takes
about 10min to do the calculation.

Using Windows XP and Excel 2002.  When I protect my spreadsheet and
subsequently click on any cell, locked or otherwise, I get a dialog box that
says "The macro "2006SeniorScoring.xls!SuperSeniorAlpha" cannot be found."
I do not have a macro by that name although I did at one time.  ...

The little red traingle on the corner of a cell that contains a comment, can
it be made bigger?
Thanks
Mike

I am trying to get away from hand written paperwork at work, it
looks messy and when there is an accounting mistake, it is sometimes
too dificult to read someones handwriting. Therefore I am converting
everything over to spreadsheets and simplifiying as much as possible

I have a Pivot Table Mystery ...
Maybe someone can help me solve it.
It's a bit difficult to explain ..
(This is my second attempt !)

I have a question for the Excel gurus which read these groups.  I have had
a look through the archives and as far as I can tell, there is no way to
do what I want so I thought I'd ask here.
Take the simple case of calculating forecast sales; if the market for widgets

I have a spreadsheet that containts 2 columns-Part Number and Drawing
Location.  The sheet looks something like this:
---A------------------------B-------------------------
Part#-----------Drawing Location

I am looking for an excel sheet for calculating a surface area optimization.
Example : I  have a floor 20m x 40x and a want to devide it into pieces. I
have a lot of pallets to place on that floor. I want to calculate the
optimal use of the surface area.

Hi, i've just joined the group because i want to learn about the more
'in depth' facilities of excel (and also hopefully access in future).
I want to be able to calculate from a resultant calculation (does that
make sense?).

I have a large excel document that has been typed in upper case and I wish
to change it to Proper case ie. with initial capitals only. Is there an easy
way to do this, please.
Thanks, Robert