I spent hours today trying to figure this out. I am trying to copy a
worksheet from a workbook (contains groupings and subtotals) to another
workbook. It copies it but it does not retain the groupings (drill-down
effect).

I have installed office 2007.....when excel starts, the worksheet is in
right_to_left mode and I haven't been able to change this permanently....(i
can change it just for one time, but i would like to open the worksheet in
the left-to-right mode "ALWAYS")

every time the file is opened through a macro, a message pops up
asking for updating links with other external file. I need a statement
where it gives a no to that querry and open the file

Excel 2003
Why "&" sign is changed in names to "and" text, while "and" may be in
different languages...?
It happens instantly after I entering & in text cell.

I have a spreadsheet that has a couple of dependent dropdowns.  I would like
to turn protection on for the sheet.  When I do, and I select an item from a
dropdown menu, I get a popup message saying that the field is protected and
cannot be changed.  Where am I missing how to ...

Can't find Auto Format, did excel 2007 decide not to have this function, is
there a similiar function to be used instead of autoformat?

Hi, I am relatively new to Excel and am using the 2003 version. I am
currently learning about lists. I have compiled a list of personal
data with names and addresses. I have put the Postal Codes in a
separate column.

I am new to excel but what I am trying to do is put in a contract date
say today and then have excel tell me when the contract would be
dated if it were up 60 months. Can anyone help me.
Todays date of contract plus 60 months would be date that contract ends ...

I have a column of decimal values, A1 = 6, A2 = 1.30, A3 = .30  How do
I get the Total to sum with result of 8 hours and not 7.60?
All have is much appreciated

Using Excel 2002, SP3, I have a large spreadsheet of data, laid out
roughly as follows
Project Name, Team Name, Service Provided,  # of services provided (12
times for Jan thru Dec)

I am to begin calculating rep commissions in the coming months based
on a "tiered" or "step" method.  The rep commissions will be based on
YTD sales and their commissions % will increase as they surpasse four
different "steps"--0%-100%, 100.01-125%, 125.01-150% &  >150% of YTD

Here I have one question regarding filtering the dates in excel
I have the column where the date and I am using the Field days option for
the filling. I tried the Autofilter but couldn't filter the dates that I
need. The fact is that I need to show only the every 20th day of each ...

I am trying to do something and not sure if that is possible.
Say in Sheet1, CellA1, I have a comment '= IF(and(b1=c1, d1=e1), "Do This",
"Do That")
Question is how can I call  the formula part in a vba to be paste in a

I am creating a sheet to log sales. One of the columns is a drop down list to
select Cash, Cheque or Credit Card. The adjacent field shows the value paid
by that method.  There will be a number of rows of data.
I wish to do a formula at the base of the spreadsheet to show the ...

I want to using Access grab information in Outlook Templated Messages and
place them into a database.