I have an excel file that contains 80 worksheets.  I want to automatically
convert each worksheet into own new excel file.   How can I do that without
copying and pasting?

I cannot change a column to show dates as mm/dd/yy.  Some cells will change
but others are frozen on dd/mm/yy.  Nothing I do will clear it and lock in
the format I want.

In Excel 2003 i use the "Open Favorite" button on my toolbar.  I put a bunch
of shortcuts to folders I use often in my favorites so this is a great way to
quickly find files.  The probelm is that when I click the "Open Favorites"
button the "Files of type" defaults to "Shortcuts ...

How do I format worksheet so that consecutive repeating values in a column
will appear only once in the first row and suppressed in the following rows?

I am trying to import a txt file into Excel.  When I go through the wizard, I
choose "fixed Column" width- next- then I have to put my break lines in at
certain measurements.  These txt files are always the same so is there a way
to change the default break line settings so they ...

hello and greetings, my microsoft excel having problem  in my office, each
and everytime i try to open a dexcel doc from another pc through my computer,
it says document locked for editing! but how come? no one is using it and not
only 1 document but all the documents in that pc ...

When I double click on an excel icon , excel program opens but not the file ...
I can open the file only by the tool bar functions...
I tried to completely re install, but It is the same ...
Any one can help

I want to setup a time sheet for 20+ employees, with the breakdown of regular
and overtime hours with calculations weekly.
I currently have a weekly time sheet with all employees, hours they worked
daily for the week, then a column that totals all the hours and calculates

When I load a worksheet that I got from someone else, there are columns A
through IV, and Rows 1 through 65,536.   Because of this, when I go to move
the scroll bar on the right to get down 30 or 40 rows, it is virtually
impossible, as just a small move in the bar moves you a ...

I'm trying to add-in the Analysis TookPak and I keep getting the error
message that it cannot run this add-in and the feature is not avaiable. It
asks me if I would like to install it now, I click Yes, but then I get a
message saying it cannot access the file 'analysis32.xll'.

When I open Excel to start a new work book, the column and row headers are
both numeric. How do I change the Column header to alphbetic?

Using Office 2003 Pro
Is there a way to set default date format to medium; i.e, 12-Nov-05?
I have Win Regional set to dd-mmm-yy, but Excel defaults to short date such
as 12-11-05.

Ver:Office 2000
While Using Excel I set The backup option ON (by Save AS - Tools - General
Options - Always Create Backup Checked) so that every time I save, a backup
is created, Now my problem is that this backup file in created in the same

I have a workbook that upon saving, i wish for it to produce a carbon copy on
a shared drive for public viewing, but keep the original secure.  And each
time I update the original, the version on the shared drive will be
overwritten.

I'm REALLY new at pivot tables and need to get up to speed quickly. They
seem very powerful, but I'm just starting.
Could you tell me how to get actual data in the data fields? I just get
counts. I want the actual data (names not count).