General

AVERAGE cells on another worksheet when the range is calculated
I am trying to average a range of cells on the main worksheet of my workbook, but the cells to be averaged are on another worksheet in my workbook where the range of cells to be averaged is calculated from an input cell on the main worksheet ... 15 Jan 2010 10:29

Subtotals on imported data
Hi there, I am using Excel 2007. Whenever I import data (running off a view created in SQL Server), the subtotal button is not available for this data range... is there a setting to activate this? Thank you in advance! W ... 15 Jan 2010 09:22

stock control spreadsheet
Does anyone know where i can get a stock control spreadsheet from? are there any online at all, preferably free.. Thanks ... 15 Jan 2010 08:16

pivot table cannot group selection
Hi, I'm having the same error :-( I have tried the things suggestion in this trail but still am getting no where. Example of dates: 01/05/2009 08/05/2009 08/05/2009 08/05/2009 08/05/2009 08/05/2009 15/06/2009 Any help? "Ron Coderre" wrote: I'm glad you figured it out......and thanks... 23 Jan 2010 21:04

ROC curve
Hello. I want to know how can I make an ROC curve for my data population and which software do I need to do it? ... 15 Jan 2010 05:00

Excel 2003 compatibility issue
Hi, I am using Windows 2003 Enterprise 64 bit edition. I want to know whether if Excel 2003 is compatible with the above mentioned operating system. If Yes then do u have separate excel edition for 2003 64 bit server. If No is there any other office application which is compatible with the above mentioned s... 15 Jan 2010 01:46

how do i set up a "send as attachment" shortcut in in a document
I would like to include a "hyperlink button" on an excel document that would enable the viewer to enter data, click on the button, and then have the document sent to an assigned email address as an attachment. ... 15 Jan 2010 09:22

changing the title for a spreadsheet shown in IE
When I use IE at work to show a spreadsheet from a server, it uses the entire file path as the page title. Is there a way to change this, so that IE can pick up a title from the spreadsheet itself? I believe this is IE 6. Thanks, Mitch ... 14 Jan 2010 21:25

Ability to Group and Ungroup while in Protection Mode
I have a worksheet that I'm trying to protect the formulas (with some cells that are unprotected for user input). Because it is rather large, I want to be able to group it so that the user can toggle between a summarized or detailed view. I'm using the grouping functionality and have preset the groups. How... 14 Jan 2010 20:19

My Home tab closes after every click
It used to stay open all the time. How can I get back to that state of affairs? Thanx ... 15 Jan 2010 09:22