| Thread | Last Post | Replies |
|
| New DB Query problem | 02 Apr 2004 00:16 GMT | 2 |
In Excel 2002, when I go to Data-Import External Data-New Database Query, I get a "Choose Data Source" window that displays many items including Oracle, dBase Files, Excel Files, and MS Access Database. However, when another user logs onto the same PC and tries the same process
|
| Protect Worksheet method fails - Spanish | 02 Apr 2004 00:11 GMT | 4 |
I have solutions developed in English Windows (2000 pro) and English Office (2000 pro) which fail on a Spanish version of Windows and Office while using the Protect method. The following error is displayed:
|
| red triangles in headers | 01 Apr 2004 23:28 GMT | 3 |
What are the red triangles in the header of some columns, and how do I get rid of them?
|
| Merge Printing Part of Spreadsheet | 01 Apr 2004 23:23 GMT | 1 |
Temporary working on Excel at Work. Need to write to a number of people on the spreadsheet. So far, I've sorted, then copied data into another spreadsheet. Then when I've done mail merge, where it says Entire Worksheet, I click on this. Is there a way of marking the block in the
|
| Excel - Spreadsheet/cell adjust | 01 Apr 2004 23:22 GMT | 3 |
For the contents in a single cell, how do you adjust lengthy text to fi automatically -- Message posted from http://www.ExcelForum.com
|
| Computer won't read files. | 01 Apr 2004 23:16 GMT | 2 |
When we try to open files in Excel or Word the computer tells us that the file can't be read or it is unavaileable. Dose anybody know why we can't retrieve our files?
|
| evaluating between 2 numbers | 01 Apr 2004 21:54 GMT | 3 |
hi, i need to evaluate 25 between 10 and 50, if yes, then a, if not then b. i know how to do that using the if conditions and have a lot of time using this way, i was wondering i there is another way to evaluate the
|
| Embedding A Spreadsheet Into WORD Question, Please | 01 Apr 2004 20:36 GMT | 2 |
New at this. Have created a normal "stand-alone" Excel spreadsheet, but would now like to embed it into a WORD document. Is there any way to embed an Excel spreadsheet into a WORD text document,
|
| conditions using colors | 01 Apr 2004 19:46 GMT | 2 |
anyone knows if there`s a way using conditions, to fill the cell with colors?, i mean not filling all the cells manually? ***** Posted via: http://www.ozgrid.com Excel Templates, Training & Add-ins.
|
| Disappearing chart | 01 Apr 2004 18:37 GMT | 1 |
I have added a text box to my chart. Now when I try to print all that prints is the text box not the graph. I can get the graph to print IF I print it on the chart window but it does not include the text box then. I want my chart and text box to print when I use page set up because ...
|
| Setting up Cell for Net Pay | 01 Apr 2004 17:53 GMT | 2 |
I created a Tax Workbook, for 2004 from my 2003 Excel program. For some reason the NetPay cell, stays blank. I have set it up the same, as the 2003 tax workbook, updated the percentages for taxes for 2004. Why won't excel show any value in the netpay cell? Am I missing something
|
| PMT result as positive number | 01 Apr 2004 17:19 GMT | 7 |
I'm using the PMT function to do some financial planning, but everytime I do a calculation for a payment it comes up as a negative number. Can I change this to a positive number in anyway? I want to use it to calculate long term payoffs, etc. and prefer it as a positive.
|
| XL97: How To Standardize Format Among Sheets with Varying Formatting In A Single Step | 01 Apr 2004 16:12 GMT | 2 |
At times I inherit multiple worksheet files, where different worksheet have different formats (margins, orientations, page sizes). T standardize the formatting among the various sheets, I try to selec all the tabs and change the formatting for all sheets at once, but whe
|
| autofilling cells | 01 Apr 2004 15:37 GMT | 5 |
say i have a in A1, b in A7, c in A9 how do i insert a in A2 - A6, b in A8 and "c" in A10 - A21 TIA
|
| I'm stuck | 01 Apr 2004 15:08 GMT | 2 |
I have a problem and don't know what to do anymore, I'm stuck. Here is the it is: I have a workbook with two worksheets where sheet1 has data in column A and B. A is employee's pass number (6 digits) B is last
|