Why can't I email a shared excel file?

I need help with a formula. I have the following formula giving me the no of unique positions that are ines 4 ...

I want to see only the cells that have contents as I need to edit those specific cells in the workbook. I tried Autofilter, haven't tried advanced filter,...

Can anybody help me with the calc to sum a filtered range?

Hi Dana, and thanks again for the following: =MEDIAN(-400,-MIN(3 + 0.02* H9, 0.05* H9),0) Can you elaborate on it? Math is a shortcoming for me, so I'm...

I am trying to get my excel sheet to count the number items received in a certain month. For example 02/Mar/09 59 04/Apr/09 62 01/Mar/9 25 01/May/09 25 I...

I'm trying to make a conditional formatting rule in Excel 2007 that makes a row of several cells where one cell contains the text "Yes" to be formatted to...

The border around highlighted/selected cells is quite thick but the background colour is barely visible compared to to older versions. Is there a way to...

Hello I have got a pivot table showing today's transactions by account number. I found that say an account has three receipts for £500 then it will be laid...

Hi All I had placed a file to be shared by 5 persons. However, only 2 persons are able to open the file and make changes while 3 persons can only open the...

I just loaded MS 2007 tonight. I was excited to find the capability of inserting equations in Word, but found that this wasn't available in Excel. Does...

Yes, I've seen this question posted all over the web. No, I've not seen a satisfying answer so far. I would like to: -) Double-click any two XLS-Files in...

I currently use the following formula to add values together from one tab to a totals page....

I have a 5 page spreadsheet and no matter what I try, it will only print the first two pages. I have checked the page breaks etc. and everything seems fine.

How to format something like 744532451500 into 74-45-32-45-15-00 this so the "-" are added automaticlly Thanks

Hi all, Is there any way of getting rid of the print area "dots" once one has clicked and set a print area? I want to display the worksheet to 200+ people,...

Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o the '). I can't set up one called 'c' though - I get the message: "That name is...

Hi all, I did a silly thing and set an area as the print area. Now, onscreen, I see the print area outlined by dotted lines. Mistake.... I desperately want...

I have Excel 2007. I'm entering data into 3 colums. Auto Complete is not working for one of my colums. It was when I first started and I can't figure out...

Hi all, is it possible for multiple formulas to be inserted into a cell? I currently have a cell in worksheet a that already has a formula inserted in it....