Ok we have some excel files that get locked.  Consist on a Win2k3 share.
Basically a user will open them up in Excel and then use File, Close but
keep excel 2003 open.  So the file is closed!
Now another user tries to open the file but gets file is open by user open

I am trying to download Expenses from my Palm Pilot to Excel spreadsheet
Please advise

I have a spreadsheet (http://iedmont.blogspot.com/) and am trying to find a
solution to scan column A for duplicates and if found, remove the cell
contents of the active cell, column B, column, C and column D.
So as an example in the example sheet, it would scan column A for data1 ...

My mailing list program accepts Excel 2000 files as input. The
spreadsheet has one email address per row. Is there a way to delete
duplicates, other than sorting and visually scanning?

Hi there hope you can help.
Sorry long explanation in the hope it helps.
One of the projects I've been working in is a NON TABULAR form which
is split into about 6 worksheets each covering a different part of the

I can't seem to find an instruction/direction for how to open Excel
files in different windows.  I want to compare a couple of charts next
to each other and every time I open a new file, it opens it into the
previous window, forever leaving me with only one file open.

A short intro: I work for a company that sells dvds and cds. Every week we
make a saleslist based on sale and expected sale of new titles. The problem
is that I have to make the same list in different formats, based on what it's
to be used for. The articles on every list is the ...

A couple times I week I run a report on accounts (account numbers are either
7 or 8 digits long) looking for 3 different issues, import the results into
Excel, and distribute the results to be worked on.  Since the same account
may have been identified by two or more of the ...

Hello Group
I am a new subscriber to the group and a fairly new Excel (2002) user.
What I would like to know is how can I count the number of occurences
of words in a column.

HOW DO I  MAKE IT SO WHEN I TYPE IN A CELL THE NUMBERS AREN'T REALLY TINY

Is there an easy way to make a cell content change to a certain color?
For example if you input say $2.00 into a cell can you have it
automatically become green?
Can you do the same thing with the background color?

How can I setup an Excel spreadsheet column (of many rows) to print
out each row of this column on a separate page?
For instance:
Column1  Column2  Column3

I would like to execute an excel file, for example, with a file name
file.xls  zz.txt
And afterwards, in that file, I would like to recover the name zz.txt.
Could you please help me?

I am running excel 2003.
If I set a row to auto fit.  and I set the cells to wrap text.
If I start typing text, it will wrap in the cells.  growing the row height
as needed.

After making a connection to a cube, and the Pivot table boxes show up in
Excel - all my Dimensions show up UN-collapsed - and there seems to be no
easy way to collapse them all at once.  Does anyone know how to collapse
them at start up or collapse all ?