| Thread | Last Post | Replies |
|
| Cannot open files by double-clicking on file | 08 Aug 2005 16:33 GMT | 1 |
For some reason I can no longer open Excel and display a spreadsheet by double-clicking on the spreadsheet file in Windows Explorer or on a shortcut. File association entries seem fine. Files can still be opened using the Excel Open command. Shortcuts involving Excel add-ins ...
|
| excel cannot complete this task with available resources. | 08 Aug 2005 07:59 GMT | 2 |
I am trying top open to large excel spreadsheets and i keep getting the errormessage excel cannot complete this task with available resorces. Choose less data or close other applications. The spreadsheet are 93.379kb and 17,113kb.
|
| Functions are greyed out. Cannot be selected. | 08 Aug 2005 07:44 GMT | 1 |
Please help. I have encounter this problem but i cant solve it. Some functions in my word and excel are greyed out when i create a new document. For example in excel, i am unable to selected the merge cell function. i have merged cells before using excel so i know its not a ...
|
| What should I do to continue printing?My Printer marks "Paused" | 07 Aug 2005 19:56 GMT | 1 |
Please kindly help me.I am printing.But the printer has stopped.It is marked "Paused"How should I carry on with my printing,pls?Tnx!
|
| Inserting item on worksheet | 07 Aug 2005 12:07 GMT | 1 |
I have 25 business names on my work sheet. I need another inserted alphbetically say for instance between 8 & 9. How do I do it?
|
| error when I open Excel | 06 Aug 2005 18:42 GMT | 1 |
I'm using windows XP with office 2000 Premium. When I open Excel, I get an error message," C:\ProgramFiles Documents to Go\DVZXLAddin.xla could not be found." Can somebody help me please ?
|
| Useing "IF(ISERROR | 04 Aug 2005 20:39 GMT | 2 |
When a field is blank on sheets 'SL' or 'JL' I get a Div error. I want it to just leave the field blank. The first formula shown below is correct but returns the error. The 2nd formula does not work. What am I doing wrong? =IF(ISBLANK(Q24),'SL&AH'!E24,'JL&AH'!E24)
|
| Make Excel's ERF function work correctly for negative arguments (. | 04 Aug 2005 16:13 GMT | 6 |
Excel 2003 seems to have broken the ERF function (available in the Analysis ToolPak). Correct behavior is that ERF(-x) = -ERF(x), but instead we get #NUM! for negative arguments - a serious error. My recollection is that ERF worked correctly in previous versions, but I'm not sure ...
|
| Regression Analysis Error message | 04 Aug 2005 15:20 GMT | 3 |
Every time I run a multi-variable regression analysis I get the following error message:"Regression LINEST() - function returns error. Please check input ranges again." If I run a single x vs y regression, the analysis completes correctly. Only
|
| What is wrong with Excel spreadsheets calculations | 04 Aug 2005 14:27 GMT | 1 |
Someone should check 2003 Excel spreadsheet calculations. KB833855 and the others does not explain why the Calc results are not the same when using the same numbers and arithmetic functions on the spreadsheet. Differences of the results do not even show any immediate consistency ...
|
| Can Excael evaluate the expression, EXP(-X^2/(A*B)) accurately? | 04 Aug 2005 14:00 GMT | 1 |
I have tried to evaluate the above expression in excel but i am not getting the results I expected. I had to prefix a zero before the (-) sign before i could get the desired results. Is it because of some settings on my system or is it a bug? I am using Excel
|
| Formula Question | 04 Aug 2005 07:48 GMT | 1 |
why won't this formula work? =(h6)-(d6:g6)/2
|
| Excel 2000 : calculation error | 02 Aug 2005 16:32 GMT | 2 |
Morning, I get calculation errors with calculations as simple as a + or a -. Here is an example : type in a cell =1.245-1.155
|
| troubleshoot external references | 01 Aug 2005 20:13 GMT | 1 |
I'm trying to link to data in another spreadsheet. The problem is source data runs from d8:d25 but i want to display it in my other spreadsheet from d17:d34 (give or take) but if I try to paste special/transpose it will not allow me to do a link. If i try to paste one cell and ...
|
| Catastrophic Failure Message | 01 Aug 2005 20:04 GMT | 1 |
I have developed an excel spreadsheet using application & workbook events, the size of which is around 700KB. The program works fine at home running on XP but when I use the program at work, after a few saves the error message 'Catastrophic Failure' appears, freezing the ...
|