Hi. I created a web form that dumps the data into a SQL server database.
This form is for three, not so technical co-workers to use and need to make
retrieving new data as simple as possible. The users would like to use Excel
to retreive the data.

Entering today's date as "013006" in a blank cell/new workbook, an
changing formatting to ANY type, returns crazy date of "8/10/1935"?
All PCs across our company appear to be doing this "all of sudden."
Date/regional settings are all normal still. Only recent change was a

How do I get excel to give an answer when two conditions must be met?  
Basically, if L42>L43 and L43>0.  If true, it goes on to a calculation.  If
false, the result is supposed to be 0.    I can get condition one to work,
but not both.  Is it even possible to have two on the same ...

I have an excel file on a shared drive.
The icon looks like an excel icon because it was saved in excel
Recently the icon changed to something else but if opened it stil
opens in excel. How does this happen. I did a save as so I have th

Is it possible to put hyperlinks into a pivot table to go to the detail in
other worksheets?  I have a top 10 list of components with issues and would
like the user to be able to click on the component to go to the list of
issues.  I thought if I put the hyperlink in the cell ...

Hello everyone!  Using E02 on XP.  Usually in the Access area and don't use
Excel much but...always learn SO much in these Newsgroups.
I have 2 folders in a shared drive that contain 2 versions of a file that
need to be compared.  (We send the ToClient file to our clients and they ...

I trying to create a custom data field within a Pivot Table that
calculates the remaining sum, in a sense the opposite of the "Running
Total In" option fo the "Show data as" parameter in the Field Settings
bar. So for example if I have the follow data items in a column:

I am trying to enter 300 or so check boxes onto and Excel spreadsheet.
I find that I can link the 'return' cell using the right click / Forma
Control / Control tab / Cell Link option but I need to do this for eac
box !

I am recording macro and want to save the new macro- recorded sheet as the
same name as the sheet tab.
I do have the tab name in one of the cells A1, using =cell("filename",A1)
Example : sheet name week1, want to save new file as week1

What do I do to this argument below if when d47 is negative but c47 is
positive, how can I add it so that if this is the case........ take
g47/d47
Here is what i wrote with error

           I want to select 2 cells in column wise from the active cell and
need to insert 5 cells between them (using
"XlInsertShiftDirection.xlShiftToRight". Can any one tell me the way to do
this task?

I have two sheets one is book 1 and other is book2.xls . In book 2 I
have Column A which has Names like x, y and z and against these name
there are certain information in column B. I also have book1.xls
Containing name of the person( x, y, and z). Now what I want if through

Is there a way for me to select an existing chart from a combobox looku
or from the lookup function or by some other means?
I am trying to create a spreadsheet with the ability to select a
already existing chart from the same or another spreadsheet and have i

I analyzed 493 out of the 500 companies on the SP500.  With the people
of microsoft.public.excel giving me guidance, I was able to take the
weighted averages of many key ratios for that index:
PE =                      17.9079254407758

We currently receive analysis data from a contractor on an excel
spreadsheet that contains more information than we need. I would also
like to rearrange the data into another excel spreadsheet that is
easier for me to look at the data. We reenter the data into a paradox