I have a PC running XP Pro and Office 2007. When I go to Explorer or my
desktop and click on a workbook, Excel opens but not with the workbook. I
have tried the Excel /unregserver and /regserver and this does not fix the
problem and the ignore apps that use DDE is unchcked. Can ...

I HAVE A MERGED CELL AND I WANT TO UNMERGED IT AND TO COPY THE DATA THAT WAS
IN THE MERGED CELL TO THE CELLS THAT HAVE BEEN UNMERGED(I HOPE THAT YOU
UNDERSTAND ME)
AND THANK YOU FOR YOUR TIME

Received an e-mail with an attached spreadsheet.  I can't save it after I
open it, even if it's saved with a different name.  Permissions are
unrestricted.  What to do?
Thanks.

Is there a key I can hold down so that when clicking on cells for a formula,
it makes it an absolute reference?  I'm using mixed references, so I don't
want to switch the default.

I was trying to plot the Scatter graph for a specified range in
different columns. I have 3 columns with specified ranges Col 1 X axis
and the col2 and 3 plotted on Y axis . I have generated a record macro
for the same and it look like the same below.

I have the following IF function in column D of a spreadsheet:
IF(c1>10,c1*2,c1*3). I need to also specify that any value in column D that
is less than 6 should equal 6. Trying to set this criteria gives me a
circular reference error. Can I use a circular reference to set a ...

Hi,  I currently have about 10,000 rows of data and need to filter and copy
and past certain amounts of data onto different workbooks.  I need to filter
by column A and copy and paste all the filtered numbers onto a different
workbook.  In total there will be about 60 different ...

I have a multi-tab spreadsheet, and all of a sudden, cells with formulae in
them stopped updating themselves.  I looked at
Tools>Options>Calculation>Automatic, and it is selected.  F9 doesn't work
either. Any help would be greatly appreciated.

I am hoping someone can help me. I am new at this VBA stuff so
hopefully I can get some help. I am trying to write a macro that will
allow me to copy one specific worksheet from a workbook that is opened
and paste it to another different workbook that is also already open.

The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900.
then I input 010101  which results into  8/27/27 , for  8/27/1927. this
really baffles me, as I tried to Clear All to no avail.

I am trying to create a drop down list of employes.  I would like it to
auotmatically bring up each employees specific pay rate in another cell.

I have a list of numbers like this 3175AAA0101. I need to convert them all to
this format: 3175AAA0110141. How do I do it?
Byron

How to extract time and date from a date time value.
Ex : 2/2/2007  14:00 , i need the date and time in sepearte cells, how do i
go about doing it, please advice.

I have a spreadsheet (not userform!) with various textboxes and
buttons. The system works fine except when the user clicks a button it
appears to stay clicked giving the effect of a toggle button (and no-
they aren't toggle buttons :D ).

A friend has asked for some help and I'm not sure where to begin so
that the best solution is created ...
This person works for a Community Center, responsible for sports
activities.  One of the things he keeps track of is which referees