Hi for some reason I now have to save my work for any formlas etc to change
when I update a worsheet,  how can I stop this as it is a pain and sometimes
I need to do changes to see how they work before saving the work.
Many thanks

I've verified that Excel 2000 and 2008 exhibit this behavior, but open
office does not.
Format a cell as "Text".
Enter something like "01234a" into the cell (must be some number with

After the excel crashing last time, I can't open excel file directly. That
means I double click the excel xls file, it will only open the excel
application but no any excel sheet will open even a blank new excel form. I
need to open the excel application first, and then click open ...

Help!!  I am creating a spreadsheet to handle a relatively complicated
cashflow analysis.  I was doing fine until I started replacing explicit cell
references with named ranges.  All of a sudden, I started getting circular
reference errors.  To cure them, I tried going back, in ...

I have a sheet that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another sheet I have the
a similar format with the same columns. I need to check I need to move
the values of the order to the second sheet but I must check against

some functions like countif use criteria as their parameters.
I need help on criteria. ">100","*EXCEL" etc.
any articles or tutorials there?
Thanks in advance.

I am using excel 2003 and did something to change a default and I don't know
how to set it back.  Whenever I create a pivot table and drag a field into
the data area the default behavior is to count the items.  I thought it used
to sum them by default.  Does anyone know how I can ...