Is there a way of setting a designated sheet to open first
each time you open your worksheet so no matter what the
last sheet was that someone worked on, the designated
default sheet, always appears first.

Everyday we're printing dtr forms and preventive
maintenance sheets. All in all about 35 files we have to
open and just print.
Is it possible to just list all these filenames in one

I have a table set up as a database in Excel 97.
It has about 36 fields including a field for recording the
date a change is made to a record.  Is there a formula I
can place in that cell which will automatically enter in

I have a worksheet that I put a password for security
reasons.  I have forgotten the password to unsecure the
workbook.  Now what can I do?

I need to know how to make a cell reference just the filename of the workbook it is located in, as well as the filenames of other workbooks that I dictate. If the workbook name with address is "C:\Files\Folder\Mementos.xls", then I want the cell to display "Mementos". For ...

I am trying to do something simple (I belive but can't seem to get i
right.
I have a set of positive and negative dollar amounts in a column.  
have a set of descriptive text for those numbers in another column.  

First ley me thank you in advance for reading this post.
Here's my problm:
I have a sheet that performs a large number of functions
based on the days of the week. The sheet draws information

I don't seem to be able to have a negative column offset
with my vlookup (Office XP).  I seem to remember doing
this in past excel versions.  Is there a new function or
workaround?  Thanks.

I am working with MS office 97. can u tell me how to
increase the number of columns beyond 256.
Can you tell me how to merge more than one excel worksheet

Using worksheet formulae, not VBA, I would like to be able to convert
a time range (for example 22 Jan 2004, 6am through 22 Jan 2004, 9am =
38008.25 to 38008.375) into an array of discrete time values (for
example every 30 mins).

I want to create a limitation so that the entry into the
different areas of my form are not greater than a specific
cell-also entered by the user.
translated:  the values of each product entered by user

Hi, I'm trying to create a workbook that will have data from each wor
day of the month on different worksheets.
So i'm trying to create a macro that will create a new worksheet an
name it the date value that's in cell A8.

I understand the concept of absolute and relative
formulas. But what I can't seem to make happen is this
scenario:
   A    B    C   D        E                F

I am trying to write a formula that returns a value in say cell Q6.
based on the following conditions
(1) the content of cell A1 and then the contents of L1 (both drop dow
lists. and returning a value from one of three choices.

Does anyone know how to use DSUM when a desired criteria
value is NULL?