After Upgrade of Excel to 2007: Withing the Developer Tab the 'View Code',
Properties, Macro and many other buttons are disabled in Excel 2007 for new
or any workbook.
I have all of the security items set to the lowest level (enable) all in the

I am trying to count rows in a spreadsheet that there are hidden rows.  
Everything I try always counts the hidden rows.  
Anyone?

I have a problem that i know there must be an easy solution for...but i have
searched and cannot find it.  I need a formula/conditional that will return
actual value if <25 but cap the range at 25 if value is => 25. eg.  MY range
is j4:j27 and the sum is in j28. Any help will be ...

Is there a way I can reverse first and last names in Excel when the first and
last name is within one cell?
When my software exports it last name, first name it brings it into one cell.

I have a gardening business with weekly, fortnightly and monthl appointments.
Then I fit other jobs in around the fixed clients. Whats the best way to
organise myself? I need Names, addresses, frequency,payment,and any other
information that would make my life so much easier!

I am getting following error message when select 2 columns and click on Text
to Column in Data option:
'Microsoft office excel can convert only one column at a time. The range can
be many rows tall but no more than one column wide. Try again by selecting

I'm working with two excel workbooks, both about 10,000 kb in size.  When I
use one everything works fine but as soon as I open the other I get an Out of
Memory message, along with some weird printer setup dialogs and sometimes a
not enough available resources message.  I am ...

I am trying to create an "easy to work with" template.  The idea is to have
th user tab through to the areas they can fill out by me unlocking the cells
then protecting the sheet.  
I have all of the cells unlocked that I would like.  Now I would like to go

When I write a worksheet, can I get excel to only show the cells used in the
worksheet instead of the whole horizontal and vertical lines of unused cells?

Attempting to auto fill a cell with a color based on a selected word or
value in a pick list.
example:    If selecting Tuesday  the Cell would be blue,  Monday the Cell
would be Yellow, etc..

Good morning --
I've made a workbook for multiple users, in which they'll enter lines of
data and watch accumulators and indices change.  As their lines of data
scroll down, I'd like the accumulators (at the top of the sheet) to remain

I use Excel 2003 and Outlook 2003, both are Office versions.

Using the following;
C1 is formatted in dd/mm/yyyyy h:mm entered value is 15/4/2008 8:00. This is
commencement of work.
D1 is formatted in dd/mm/yyy h:mm entered value is 18/4/2008 10:00. This is

Is there a way to mark protected cells by automatically creating a colored or
patterned background for the protected cell?

Hello All... What function would I use to add the actual value in a cell that
contains a formula?  
Example given below:  
Cell k2 contains =IF(I2=1,"500",IF(I2=2,"1000",IF(I2=3,"1500",0)))