| Thread | Last Post | Replies |
|
| Distmon error | 27 Apr 2004 16:06 GMT | 2 |
I am having the same prob that everyone else is describing, however have looked on the Microsoft support forum. I did a search and did no find the 2 Adobe files anywhere on my computer. I also disabled the NAV plugin...... I am still haveing the sam
|
| Detecting Screen res | 27 Apr 2004 14:04 GMT | 1 |
Is there a way Excel can auto detect the screen res of a VDU an automatically resize thing like msg boxes so that text is centred o both big and small screen resolutions rather than ending with the tex all over the place ?
|
| Template Wizard with Data Tracking (wztemplt.xla) Path | 27 Apr 2004 13:51 GMT | 2 |
We moved a Excel template utilizing the Template Wizard with Data Tracking (wztemplt.xla) add-in to a new server. We where able to update the database path in the Excel template, but now I'm wondering how I change the path in the Excel Spreadsheets created by this
|
| Kiviat Graph | 27 Apr 2004 13:07 GMT | 1 |
People, I am working with Excel 97 and I need to do a Graph named 'Kiviat'. Does anybody know how to do it? Thanks,
|
| Find & Replace in XP | 27 Apr 2004 12:30 GMT | 3 |
XP now has the ability to do a find & replace based on formatting, but i ran across an issue. If I type the word accountant in cell A1 and "accountants are fun" in cell A2, do a find and replace for the word accountant that
|
| Finding maximum value | 27 Apr 2004 08:30 GMT | 3 |
I want to find the maximum value in a column, but I want to ignore the negative and positive part of the value. Basically, the maximum difference from zero. Example: the maximum value I am looking for will be -0.467.
|
| Lock workbook. | 27 Apr 2004 06:57 GMT | 2 |
I have two workbooks, in the first I have some Forms (for me its programs workbook) and in the second I have datas. Is there some way how can I lock (write) the data workbook only for Macros-Forms. I dont want still open and close this workbook
|
| Circular reference error | 27 Apr 2004 04:10 GMT | 3 |
Using Excel 2000. I have a workbook that is already saved. When I open the workbook I get this error. MS Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you.
|
| search of a string in a cell and counting occurences using COUNTIF | 27 Apr 2004 02:40 GMT | 1 |
i need to separate out items which are in a column with cells containing 1 or more of these items delimited by commas. i need to export them to another worksheet within the spreadsheet which lists down the items individually per cell and then, i need to count the occurences. i tried
|
| Excel Help | 27 Apr 2004 02:01 GMT | 3 |
I want to make a cell as a list box. How do I do this without actuall putting a list box in that cell? Thanks TyeJa
|
| Cell extraction from Multiple worksheets | 26 Apr 2004 23:49 GMT | 8 |
Hi group, I am new to this newsgroup and am hoping that you can help me out. I took a software/hardware inventory of all the computers in my work's network and imported them all into excel, in their own worksheet. So I have one file,
|
| Automatically copy input from one cell to another | 26 Apr 2004 22:54 GMT | 2 |
After I enter a value in one cell, how can I have it automatically enter it into another cell, within the same worksheet, or into a different worksheet. Thanks,
|
| Combining 2 cells - Lose number format when combing | 26 Apr 2004 22:39 GMT | 6 |
I have a range of scores for a test in cells A10 thru A100. In Cell A1 I have a the formula =COUNTA(A10:A100) that returns the number or n of scores. In cell A2 I have the formula =SUM(A10:A100)/A1 which returns the mean for the range. In cell A3 I
|
| On-screen form template to database | 26 Apr 2004 21:58 GMT | 1 |
Good day to all, I would like to create an on-screen form (for financial assistance requests), with multiple fields (e.g., date, name, address, phone #, type of help requested, amount of money pledged, etc.) that I can fill out
|
| how to make a budget | 26 Apr 2004 21:53 GMT | 1 |
:( My husband owns a propane business and wants me to build a budget fo our customers. Can anyone tell me how to go about doing this?? I wa told Excel would be a good place to start but how??:confused --
|