I have an excel document that was created in Excel XP, and it opens fine in
Excel XP. When I try to open it in Excel 2003, it tries to go thru
'calculating cells'. It hangs at 5% on a mid range laptop and 25% on a high
end desktop. Is there a fomula converter or something I cna ...

I export data from a program called OpenView Service Desk into a
spreadsheet. This spreadsheet is then imported into Access and queries
performed on the imported data. This data is then copied and pasted
into a different spreadsheet where calculations are performed. In one

I'm trying to convert a table of data into a pivot table. The table has
twelve data columns for months of the year. Is it possible to convert the
twelve month columns into a time dimension in a pivot table?

Hi, I will try my best to explain. I need to have conditional formatting as
such:
3 cells in adjacent columns. first has name, second has text missed punch,
third has date of error. I need the 3 cells to be removed(possibly to

I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if possible):
If C6 = 3 then C18 = "X" otherwise if C6 > 3 then Insert a drop-down box
with values "Yes" and "No".

How can I get a running total in Excel working in lbs and ozs

Hi, I just found this "feature" at Excel formulas today.
Please, have a look at: http://danielgudang.multiply.com/journal/item/192
(in portuguese, but images show all)
Let me explain:

Using macros, how can I move a sheet called TOTAL to become the very last
sheet within a workbook?
Your assistance will be appreciated.

Has anyone seen this (Application.MemoryUsed) work or fail to work in 2007?
This morning a coworker fired up an Excel app on their spanking new PC
running Office 2007.  An Error (Type mismatch?) was raised when the code
hit: Application.MemoryUsed.

i am  new to excell and i have a document that i got from work that has
multiple worksheets, that drop down in the "name box" it says i get them but
i cannot get back to my original document.. sorry dont know how else to
describe this. thanks T

I have recently bought a new IBM Thinkpad R60 with Vista preinstalled. I
bought Office Professional 2003. It seems to be working fine with all office
programs. Howeever when having opened Excel 2003 and pressing the NEW button,
Excel shutsdown. I get the message that Excel has ...

VLOOKUP is great for looking up a value with a single index column.  But
what if I need to lookup against two or more values?
Simplified example:
apples      5    A

I'm trying to create a macro for the following actions: select several
contiguous rows of data; click Data/Text to columns; select Delimited, Other
and enter "$"; select Finish; then return to Text to columns; select Fixed
width for the remainder of the data and Finish. My ...

I know how to hide / show the rows, but how do it so as to leave a little
plus sign in the corner that allows me to control the number of rows to
expand / contract (and I know you can do it - I've seen it on other
spreadsheets!)

Let's say that I have a value in one cell, call it X.  X is a numerical value
that needs not be touched or modified UNLESS it exceeds another numerical
value in another cell, call it Y.  If it DOES exceed Y, then it must be made
to show as EQUAL to the value in Y.  If it doesn't, ...