| Thread | Last Post | Replies |
|
| Templates in excel | 30 Jan 2008 21:20 GMT | 1 |
I need a template for excel that will allow me to figure accrued time off with vacation and sick time. Is there one?
|
| how do i change my screen when it displays sideways | 30 Jan 2008 21:05 GMT | 6 |
One of the kids was using the computer and "suddenly" the screen now displays sideways. He has no idea, of course, how it happened. What do I do to right the screen. Thanks
|
| costing | 30 Jan 2008 20:58 GMT | 2 |
usage in yds cost 1.5 $2.00 1.4 $2.00 1.6 $2.00
|
| Options menu grayed out in Excel 2002 | 30 Jan 2008 20:52 GMT | 1 |
Hi. I am running Office 2002, and the Options menu under Tools is grayed out. I tried uninstalling and reinstalling Excel, but no change. Nothing is set in protection, and the other programs in Office are unaffected.
|
| Excel 2003 "Cannot empty the clipboard" | 30 Jan 2008 20:47 GMT | 2 |
I am using Excel 2003 on Windows XP. In the past I have been able to select cells, rows, etc., right click to copy and then paste elsewhere. Now I am getting a "Cannot empty the clipboard" pop-up and cannot get around this. Help anyone?
|
| Cannot empty the clipboard | 30 Jan 2008 20:44 GMT | 4 |
I use Excel VBA to create a standard e-mail (only contains plain text). This text is linked within Excel. Problem is that it has been working but now only an empty e-mail is the result. No body text only the header.
|
| Arrow changing If statement | 30 Jan 2008 20:20 GMT | 1 |
I'm trying to write an if statement that is contingent upon a number being positive or negative and the outcome of a positive number will show an autoshape arrow to the right or a negative number will show an autoshape arrow to the left.
|
| Pivot Table Update | 30 Jan 2008 20:08 GMT | 1 |
I have a worksheet that is constantly being updated. There is a pivot table based on the worksheet. I would have expected that when I add a new line to the worksheet, the pivot table would update. It doesn't. I have other workbooks where I do this. For some reason, this one ...
|
| Wildcard * for SUMIFS | 30 Jan 2008 20:00 GMT | 2 |
I am trying to do a SUMIFS calculation and the wildcards are not working. Here is the formula: =SUMIFS('Rents'!U:U,'Rents'!Y:Y,"y",'Rents'!P:P,"*",'Rents'!O:O,"*") Where 'Rents'!O:O is a dollar figure. I need it to include data from the
|
| Find Record Box | 30 Jan 2008 19:58 GMT | 1 |
I am trying to place a "find record box" in a form using the combo box wizard; however, the wizard does not give me the “ Find a Record on My Form…” option. I was trying to place it in the header (which I have done many times before), but it won’t give me the third option. I ...
|
| Limits to values in auto filter dropdown in Excel 2003?? | 30 Jan 2008 19:56 GMT | 3 |
Are the any limits to the # of values displayed in column header dropdown when using Auto Filter in Excel 2003(SP3)? I have a list of 25K values many of which are not being displayed in dropdown. Thanks
|
| Shared Workbook - Best Practice | 30 Jan 2008 19:45 GMT | 8 |
I would like to be able to have one person modify a workbook while many people look at (but do not modify) the same workbook -- all viewing at the same time. What is the best method to do this? (It's important that the viewers not be
|
| how do I add a spreadsheet into a new sum? adding across spreadshe | 30 Jan 2008 19:25 GMT | 6 |
Ok, so I have this formula =SUM('2'!C3,'3'!C3,'1'!C3) but I will need to eventually add more spreadsheets into that sum. Instead of having to type that in each time, is there another formula/function that i
|
| linking sheets in the workbook and getting rid of the ZERO | 30 Jan 2008 19:23 GMT | 3 |
Ok. I am thinking this is a format problem, but when I go to link sheets in the workbook and copy one sheet to the other, I am getting a zero in the columns. For example when I enter a number 3 on sheet 1 and want it to go to sheet 2, no problem, but when I enter a number 5 ...
|
| Disable the Delete Key | 30 Jan 2008 19:20 GMT | 3 |
Is there a way to disable the use of the delete key or change it so that when it is pressed, it displays a zero? I am using the Essbase Add-in and if a blank field is submitted, it does not replace the prior values in the field. I need to make sure that there are no
|