Hi, is there anyone who knows how to disable the save property of an excel
worksheet. is it also possible to do it throught VBA for excel?
many thanks in advance for any advice

I know you can't use a formula in excel 2007 which nests more than 7
deep so here is what I did
=IF(A1="cheese",$B$25:$B$32,IF(A1="Deli meats",$B$34:$B
$38,IF(A1="Desserts",$B$40:$B

I'm in the process of trying to make a spreadsheet for work but I'm
just clueless... excel is not my area of expertise! :)
The original spreadsheet has 10 columns with various pieces of
information... column D is what is important to me... column D has 5

Could anyone sort out this formula please. I've tried various combinations
but seem to be stuck.
I'm trying to use this. =SUMPRODUCT((c5:c512=1)*(C5:C512<>1))
I am trying to count blocks of 1's in a column from C5 to C512 but all I get

Okay, this is want I want to do. Have a macro that will make a copy of the
selected sheet and move it to the the end.
Hopefully some kind spread sheet wizard can provide me with answer.

I NEED TO HAVE A DROP DOWN WINDOW IN CELL A1 TO POPULATE A LIST TO B1, B2,B3
AND B4

I want to find the first and second blank cells in a column and return both
their values as variables I can then program with. Anyone know how? I got as
far as:
If ActiveSheet.UsedRange.Count < 2 Then

I collect music cds and have a big collection - i also collect the uk top 30
music charts
Over the last few months i have compiled a list of wants to complete the
project (to the end of 07)

I using Excel 2003
In page break preview I have always do some thing wrong I'm just pull the
blue line by using mouse all page was destroyed
It there any tips to return the blue line to the Default pages size setting

Is there a way to use a filter string with the IF function?
I have a spreadsheet that looks like this:
Invoice No.    Invoice Date    Invoice Currency    Invoice Value
1                       dd/mm/yyyy        USD                1234.56

I am seting up a spreadsheet that works like a bank statement,  So from
ranges g 6 through g29 i have a balance figure.  But i will be adding
transactions to this as i go along through the month.  So in cell G7 i have
the formula:

I have a long column of numbers like this:
      A        B
1   Sales   123
2   GM%   35%

I bought Microsoft Office Standard 2007  just a few months ago and installed
it on my computer, which then broke. I am buying a new computer, and am
wonderig if I will be able to still install the Office on the new computer?
If not, it would have been a big waste of 150 dollars ...

Being new to 2007, I am having trouble with Pivot Tables.  I have four
columns of data, Part Number, Part Decsription, Item Class and Shipped
Quantity.  When I go into pivot table I can't get the pivot table to
have Part Number in one column and Part Description in the next column

Using WinXP Pro and MSOffice 2003 Pro
Everytime I do a link in Excel, it does it as an absolute link, by
default I am guessing.
I really never use absolute linking, so I would like to know if there is