The automatic update of cell references while auto-filling an Excel
formula is undoubtedly an excellent feature, that I have used many
times over.  However, I now have a need to disable it.  Can someone
suggest a good way to do that?

Running Excel 2003 on WinXP, both with all current upgrades installed.
Recently noticed an odd problem with one of the spreadsheets I've been using
for some time.  I suddenly find that if I try entering a simple formula of
the form "+x/y.n", "+1/3.1" for example, I get a message ...

Why is the merge cells function grayed out in a shared workbook? Anyone got a
fix?

I'm working at a Marina and trying to make a comparison chart for different
types of boats. I am trying to make a list, and based upon the users
selection of a boat, insert a corresponding picture to match the boat
selected from that list. I've researched other thread discussions ...

I need help for creating the file which supplies the password protected
excel file. Is that is possible by macro. If so pls tell  the macro
details.
Nitin K Goyal

I want to clear the contents of an array. I know that redimensioning an
array also clears it. So, I decided to clear the array by
redimensioning to zero and then re-redimensioning it back to what it
was. So, I wrote the following:

I have a rows of text which have html code <br> and I want to replace
that with a line break.  can i do a find and replace? I have about 2000
rows, too many to do by hand.
my text appears as such

I have a workbook with a date on worksheet 1 that indicates data has
been entered for that month.
On worksheet 2 is are columns of numbers with an average for each
column at the bottom.  I would like the average to use the date on

Hi, does anybody know how can I make a new macro just recorded appear i
all workbooks ?
I tried creating a template called Book.xlt in the proper directory an
then I recorded the macro in that file, i saved as a template but i

I have an Excel spread sheet with my cost on it, and I would like to mark
this up and round the price to the next higher $xx9.99. The retail values in
the price list range from $10 to over $1000.
The basic formula that I use to calculate retail price is /.6. For example

I am using Excel 2000.
I need a formula to find particular data within an array of data.  I have a
worksheet displaying inventory activity.  Cell A1 is a cutoff date.  Cells
A4 thru A1000 are the dates of the activity.  Cells B4 thru B1000 are

I am using 2 different versions of excel and have applied a password
protection to a work book to prevent anyone else opening it. When I try to
change or remove the password I cannot find were to do it although the help
files state go to Tools, options, general. When I do this ...

with out VBA can I create a combo box in Excel that displays 2 columns

I need help in creating a macro. I have a master file X1 and it
connects to 55 other files all password protected. When i open the
Master file , it asks the protected fiel to be open to update the data,
otherwise it gives error. Can someone help me create a macro which will

I have a workbook with financial information listed. There are several
columns that I do not want people to see, so I've hidden them and protected
the worksheet. This works fine.
But now I need another group of people to view the hidden columns on another