I have a macro that will format project files based on their projec
number. in order to record the prject number. I have created a form fo
the user to enter the project number. My problem is entering a comman
line to open the form once the user selects which type of project fil

In Excel 2007 the default file format is the new .xlsx. Is there a way to
change this to use the standard .xls as the default?
Thanks

=DSUM(Membership,Membership!$C$49,C1:C3)+DSUM(Revenue,'Revenue
Projects'!$D$2,C1:C3)
I'm trying to adapt a budget worksheet from another non-profit for our use.
I don't know who the author is and I've had it a couple years, so trying to

I have a Pivot table that is connected to an External DataSource (SQ
Server) I am trying to obtain the SQL Code Generated by the Pivot Tabl
to display the dat
--

Need help!
I have created a pivot table in Excel and now trying to add another field
that appears in the field list.  When I drag it over the pivot table to drop
it, I get this error: "cannot change part of merged cell", I did not receive

I have two lists of 7 digit numbers that start with 'B' (B1234567) and I
need to highlight which ones appear in both lists.
Should be striaght forward but I cant seem to get it to work. I guess it
should be some for of conditional Formatting.

I have table like this
Date 1        Date2        Diff Date2-Date1
     19.12.05 10.01.06 0Y 0M 22D
     14.01.05 26.02.05 0Y 1M 13D

hi, I was just wondering of it was possible to work out and store the name
of a worksheet and if so how is it done?

Hello Forum,
up to now, I am working for a very long time on solving followin
problem:
I would like to insert in one cell a whole number between let's sa

I need to enter a number of hours into a cell and it will work out the
amount in minutes. Obviously i could do this with a calculation in
another cell (=sum(A1*60)...
However i need it to work it out in the cell that i put the number of

I suspect that (since I didn't get any response on my previous request for
assistance) I may need to approach this in stages ...
Assuming that Information Rights Management (IRM) won't give me the detailed
permissions I need, basically, here's what I need:

Have table like this
Date1        Date2    Diff Date1+Date2
     19.12.05 10.01.06 0Y 0M 22D
     14.01.05 26.02.05 0Y 1M 13D

I have been using Weeknum for some time.
The second parameter is to define whether the week starts on Monday(2)
or Sunday(1)
The first of the year 2006 was a Sunday.

Is there a quick formula to apply a protection code for multiple sheets
without having to protect each sheet one at a time??  
Actually this appears to be quite crazy that you can't protect all
sheets at once.....    Hopefully Excel 2007 will allow this.   Thnaks

Is there a way to wrap the long date format. [$-424]dddd, dd.mm.yy.
I want the date to be wrapped under the day, but the cell format wrap
does not do that. Merging more cells, concatenate or text () is not an
option.