| Thread | Last Post | Replies |
|
| Microsoft Office India Live | 24 Oct 2004 21:46 GMT | 2 |
Dear all Indians, This usergroup is for you Indians and by you. Come and discuss Excel (and other Office packages) in this usergroup. International residents are also invited . Click here to join :
|
| how auto enable macro ? | 24 Oct 2004 18:34 GMT | 2 |
When my excel macro starts, it asks to user to tell if he enables macro or not. How can i do if i don't want user to answer to this question, but auto enable macro without any user help ?
|
| income/expenses spreadsheet for small shop | 24 Oct 2004 17:45 GMT | 2 |
I need a simple spreadsheet to keep a log of daily takings and expenses for a small hairdressing salon
|
| probleme to open excel document | 24 Oct 2004 16:52 GMT | 1 |
when i open my excel documents, the excel 2003 run but the document don't show in the screen. and when i try to open the document by file - open - choose th document, it's open successefuly
|
| Prevent duplication of a label in a range? | 24 Oct 2004 16:39 GMT | 1 |
I want to be warned that I am entering a label into a range which already exists in this range and thus avoid duplication. Office 2000
|
| Problem about the data refer path. | 24 Oct 2004 16:28 GMT | 1 |
I do all the work on the network driver, says L:. For example, I have a excel file on the L driver, named XXX.xls. One field in the file is refer to a field in another file on the L driver in following path: L:\aaa\bbb\ccc.xls. But do not know when i find that this field in XXX ...
|
| Excel Autofiltering | 24 Oct 2004 14:17 GMT | 1 |
Greetings all, Just a quick question about something that has been getting on my nerves with Excel lately: how come sometimes when you do an autofilter on spreadsheet data it tells you in the bottom left corner how many records
|
| show menu and bars | 24 Oct 2004 13:26 GMT | 1 |
I have an excel sheet where all bars and excel menu are hidden. How can i make everything back to visible using only Key combinaison ? thanks a lot, Maileen
|
| Recalculating a custom function | 24 Oct 2004 05:55 GMT | 4 |
I have made a custom dice rolling function for my spreadsheet as below. The problem is that it does not automatically update. Normally, having randomize(1,6) or whatever will recalulate when i press F9, but to make this recalculate, I have to go into the cell and press enter. Is ...
|
| #div/0! | 24 Oct 2004 05:54 GMT | 13 |
I am trying to get an average score for each month of the year and I have a spreedsheet where the total is the following formula =AVERAGE(H22:H33) But until each month ot the year is completed it only shows #div/0!. Is there a way to force it to show the average if you only ...
|
| change the year in a list of dates ex 1/3/2003 to 1/3/2004 | 24 Oct 2004 05:50 GMT | 2 |
I have a list of dates, all in the year 2003 1/3/2003, and 5/17/2003, I want to change just the year to 1/3/2004 and 5/15/2004 in the whole list. How do I do that?
|
| Pivottable last 6 months | 24 Oct 2004 05:36 GMT | 1 |
I have a pivot table with customers down the left side (rows - (Name)) and the dates along the top (columns (date)) with sales as the data (Sum of Sales). All of it is linked to an Access db query so the info is constantly
|
| How to join files??? | 24 Oct 2004 04:12 GMT | 2 |
Dear members, I have sever exel files and I would like to join them (make just on file), do you have any suggestions? or any program which already doe it. All the files have the same format and the same information.
|
| Weird Coding | 24 Oct 2004 03:12 GMT | 3 |
Hi, this is my first post and I was hoping that someone could help. My friend the other day installed a program that caused him to lose all of his excel files. Fortunately, he was able to do a system restore and was able to retrieve the files that were lost. However, upon opening ...
|
| Text colour for certain words ? | 24 Oct 2004 00:48 GMT | 4 |
I have an Excel database, how can i get excel to mark every instance of a certain word in red ?? I know there must be a way, but i'm not very excel literate yet ! Cheers
|