| Thread | Last Post | Replies |
|
| how do I delete "paymee V#" from excel? | 28 Apr 2008 18:00 GMT | 1 |
I need to get rid of a program with in excel called "Paymee V3" instead of being helpful it is just a pain. Does anyone know how to delete? It cannot be done from programs and I know of no other way...Thanks!
|
| I have Excel 2003 why cant I open a xlsx excel file? | 28 Apr 2008 17:38 GMT | 2 |
I have Excel 2003 why cant I open a freaking xlsx file ?
|
| Question relating to the OR function | 28 Apr 2008 17:30 GMT | 19 |
I half-noticed a long while ago that whenever there is an error within the arguments to test in a logical function, the final result will also be an error. But it just stroke me today that if I have something like...
|
| Printing without formulas showing | 28 Apr 2008 17:11 GMT | 1 |
I have a spreadsheet that has several formulas in it. Most people simply enter the data and I print. However a few employees who are offsite need to handwrite on the sheet. Is there an easy way to print my worksheet with the formula cells appearing blank? This would save me a ...
|
| How do I select several control buttons at once on an Excel sheet | 28 Apr 2008 16:53 GMT | 1 |
I can't find the pointer tool, part of drawing tools pre-2007. I want to select several form control buttons and set the format properties to print object, so that when my students print the sheet for their coursework the buttons get printed.
|
| Data Validation - Allow numbers, comma, - and space | 28 Apr 2008 16:30 GMT | 8 |
I am trying to have data validation for a cell which only allows users to enter numbers [0-9] , comma (,) , hyphen (-) and space. User should be able to enter a combination of these characters. For Eg: 3, 45-60
|
| make custom buttons for macros on quick access bar excel 2007 | 28 Apr 2008 15:57 GMT | 2 |
It used to be relatively simple to add a macro to the toolbar, make/edit a custom button image to go with it, and voila. Now it seems you can only accomplish with a lot of whoops, programming skills, and then still end up withsoemthing much less easy to use than the
|
| Fixing a link | 28 Apr 2008 15:16 GMT | 1 |
I have a file using external formulas in the cells. i.e. =FM(XX, MM) gives a value using an external software's formula which is "FM". However, when my colleague uses the same file, he sees it as: =C:/ccc/ccc/FM(XX, MM) and needs to replace the C:/ccc/ccc part everytime.
|
| help | 28 Apr 2008 15:16 GMT | 3 |
I want to record a macro which is more than 255 characters, kindly help, my formula is as follwos =IF(AND(S152="IncidentLow",O152<=168),"Pass",IF(AND(S152="IncidentMedium",O152<=24),"Pass",IF(AND(S152="IncidentHigh",O152<=8),"Pass",IF(AND(S152="IncidentUrgent",O152<=4),"Pass" ...
|
| Use the content of a cell in the sum (or other) functions | 28 Apr 2008 15:12 GMT | 2 |
Example of what I want to achieve: Column A has many rows with numbers. D1= a text cell that reads textually A1:A20 I am looking for a formula that will give me the sum of the VALUE that D1,
|
| How do I compare two versions of an excel document? | 28 Apr 2008 14:57 GMT | 1 |
I have been given an updated version of a spreadsheet and I have the original on my computer can I compare the two so I can see what has been changed without going through line by line
|
| pivot table top 60-80% | 28 Apr 2008 14:50 GMT | 2 |
I would much appreciate if someone could tell me how to extract the following from a pivot table: I have a table of total sales per person and per region, and would like to see only the top 60% or the top 80% of sales.
|
| Conditional Format - Date + 7 | 28 Apr 2008 14:21 GMT | 2 |
I have a spreadsheet with a start date in column F starting at row 3. Column M needs to be highlighted a different colour if the value in F3 goes over 7 days. If there is already a date in column M, then this should be ignored. However, if the date in column M goes 7 days or more ...
|
| Can't open pivot table field list | 28 Apr 2008 14:07 GMT | 1 |
I created a pivot table in Excel whereby the data is in one worksheet and the pivot table is in another worksheet. When I view the pivot table I can't get the field list to open. I tried clicking on the button inside the pivot table toolbar but nothing happens. What is strange is ...
|
| Roundup time | 28 Apr 2008 13:20 GMT | 8 |
Is there a formula for rounding up seconds to the next highest minute?
 Signature jhodges
|