I was working properly with Excle until I loaded one of the spreadsheets
that contained a macro. After trying to open it Excel froze and from that
time is freezing when I'm trying to open it.
I checked for viruses with 2 Antivirus programs and spybot 1.3.

Hi There I have  a data base of users at our company and wish to know how to
insert "@(emailaddress)" after every user in all 5000+ cells and is it
possible to import this list to outlook ?
please help

One change to the first question. 'Person x' doesn?t send the Exce
datasheet, but he saves it on an Intranet where both person have acces
to the datasheet
--

I have a spreadsheet (in Excel 2002) that I want to publish on a
website,with full spreadsheet functionality, so that a number of people can
all work on it and jeep it up to date.
So, I used 'Save as webpage', 'Publish', and I selected 'Add interactivity

How can I get each row number to be labeled within the pivot
table...and also show a total row count along with the "grand total"?
Example:
1, Apple, $3

Hi guys.  First time poster here so be gentle with me.  I am looking fo
some assistance averaging a range of 1 to 3 numbers.
Here is what I have so far.
=(D3+F3+H3)/(IF(C3=0,0,1)+IF(E3=0,0,1)+IF(G3=0,0,1))

I have a spreadsheet which I'm trying to show the sum of each item, but the
pivot table wizard only gives me a count.  It will do a sum for each column
or row, but not each item.  I can do this in a snap if I import the
spreadsheet into access and run a crosstab query, but the folks ...

Are you sure that you need all those decimals in the
original worksheet/workbook?
If you don't, you can round them (or truncate them) to the
proper 2 decimals and format your cell to 2 decimals.

Good day to all, my question is: exists one way in order to moderniz
more formulas at the same time? Example: we leave from the formula:
se([pippo.xls]gennaio!$H$4="SI";"X";"") it is possible to obviousl
replace the word January with February etc at the same time on othe

How do I use th valid range for a normal RGB color, i.e. 0 to 16,777,215
(&H00FFFFFF) to format a cell using VBA.
Your help is appreciated!

I want to enter numbers from 001 to 999 into cells formatted as text.
How can I without typing 001, 002, 003, etc individually into each
cell?

I am new to Excel 2000 and attempted to save an Excel
Document as Web Page that can be changed interactively.
However, when I change the content in that spreadsheet via
IE, it seems that the underlying spreadsheet is not

Does anybody have, or are smart enough to write, an excel macro that will
produce random numbers WITHOUT duplicates. I can't see to get my head around
this problem

is something like this possible (multiple criteria in the braces)?  I know
it does not work currently, but I am hoping there is a way to do something
like this without adding 2 sumproduct formulas.
=SUMPRODUCT(--(QUERY!$A$2:$A$31311={$B16,$C16}),--(QUERY!$F$2:$F$31311=J$3),

I need to have Excel return the price of an item when I enter it.  I work
with lists and I frequently type in an item and then I manually enter a
price for the item.  The cost of the item is known, I just have to look it
up in a book and then manually type in the price.