General

Saving file
I have an excel 2007 macro enabled file with extension xlsm. Whenever i make some changes and then want to save the changes it does not allow me with message appearing a sharing violation save in different file format. Please advise. ... 10 Mar 2010 09:42

Using one source list for two depends drop-down list
I am trying to use the same drop-down source list for two depends drop-down depends lists. Any idea?? Thx. ... 10 Mar 2010 10:49

How do I transpose a large amount of data from rows to columns
Hi Herbert, Many thanks, this looks like exactly what I need! I suppose I can copy my date into your sheet and then use it. There is only one thing as I get an error message: Run-time error "9" : Subscript out of range "Herbert Seidenberg" wrote: Thanks again Martijn Excel 2007 Transpose... 10 Mar 2010 06:24

IRR error
Here is the question below I am working on in a Corporate Finance class. (Default risk) You buy a very risky bond that promises a 9.5% coupon and return of the $1,000 principal in 10 years. You pay only $500 for the bond. a. You receive the coupon payments for three years and the bond defaults. After liquidat... 10 Mar 2010 03:05

Open a file without using Office Live?
How do I open an excel file without activating Office Live? ... 10 Mar 2010 09:42

How do I make into a dollar format when in a formula?
"We have been asked to contact you by our client 0, regarding your past due invoice for 7896.98. Their records indicate that payment has not been received as of the date of this correspondence, and is therefore listed for collection. This balance may include finance charges. " How do I make the 7897.98 w/... 10 Mar 2010 03:05

What causes the keyboard arrows to move the page, not the cell?
... 10 Mar 2010 03:05

Fill down formulas in existing excel docs stopped working
A have a large number of excel docs that use fill down and fill series and suddenly the formula's have stopped working. Even if I re enter the formula in the cell I can not get it to work. Any help greatly apprecialte ... 9 Mar 2010 23:46

I am having troubling opening an excel document.
I am trying to open an excel document. I did work for my class on another computer with the same version of office that i have, which is 2007. But mine is enterprise. I dont know if that makes a difference. When i try to open it on my computer the workbook does not open correctly. When i originally saved the wo... 10 Mar 2010 09:42

SUMIF
I have two columns. First column contains dates, second column contains numbers. I want to sum all numbers for a specific month and year (i.e. sum all cells with date of 12-2009) Thanks. ... 9 Mar 2010 23:46