The already infamous 850*77.1 calculation error found in Excel 2007 shows
different behaviour under different OS:
- when running Vista the result is 100000 (instead of the correct 65535) !
- when running XP the result cannot be calculated (Excel displays "the

Currently if I open different workbooks in Excel (Office 2000) they are
under the same taskbar 'tab'.
How do I get it so each workbook has its own 'tab' along the taskbar?

I'm using Excel 2003 and for instance I have a following table:
     A     B
1  2008  W
2  2008  W

I wish to open an Excel file via a script and run a specified macro,
then save the file at a certain time each day. I looked up the
Microsoft site and found the code below which Opens all files in a
directory, runs a macro on all then closes. It pretty much does what I

I've got 3 columns I want to sort based on the middle column, something I've
done many times. When I try to sort on this particular spreadsheet, I get an
error message I've never seen: "This operation requires merged cells to be
identically sized."

Hi, I had tried to enter a 12digit number in a worksheet but after entering
it its not showing the coorrect number.Eg Iam trying to enter 857268578633 in
the work sheet but after entering its showing 8.57269e+11 Why its happened
Like this can you please explain me

I would like to prepend all text values in a column with "\". What is the
easiest way to do this if there are thousands of rows?

I want to know how to remove the bexes that are in the excel? I have
a
data and design and I need to removes extra boxes so it will have a
professional look? and what is the name of this feature?

Cant understand this
This works from sheet1 to sheet`invoice`   =Sheet1!J28   (this is a number)
But this doesnt from sheet 1 to sheet`invoice`   =Sheet1!D6    (this has
cells merged and is a name)

i require to know what category my due dates fall in, 30-60, 60-90 or
90-120 ?
i already know how to do this, with a formula like:
if(and(days360(AJ2, now()) > 30, days360(aj2, now()) < 60), "30-60",

I have a formula that puts a currency value in a cell (assume A1).
That value can be anything from £0.00 upwards.
Dependent on other factors, if the calculated value of Cell A1 is £0.00
(zero pounds), the formula may enter £0.00, or it may leave the cell blank

I'm trying to get the sum of a set of cells, where the set is
determined by the result of a calculation.
Here's what I want to do:
- If 0 <= a1 < 30, return 0

I have a workbook that has 5 user forms.  One of the user forms opens when
the workbook is opened.  On the main user form i have 4 command buttons. Each
which opens a different form.  I would like to password protect one of the
command buttons (user forms).  Is this possible and ...

This is probably a really simple thing to do, but I can't figure it out and
can't find it in the help anywhere.
I have a worksheet that has rows of data. I periodically enter more rows as
time goes on. I'd like to be able to write a formula that summarizes data