| Thread | Last Post | Replies |
|
| Error Saving: "a formula in a cell... could not be converted..." | 10 Jan 2008 22:05 GMT | 1 |
Just entered an array formula in a established worksheet... don't know if that is the problem, but like Sherlock says... (The formulae are the result of another thread on this Excel board.) Error msg when trying to save file:
|
| CHIDIST parameter bug? | 09 Jan 2008 04:32 GMT | 1 |
I'm using Excel 2003 (SP2) in a spreadsheet reporting p-values from statistical Chi-Squared tests. The sheet uses the CHIDIST built-in statistical function to calculate the p-values. The function CHIDIST( x, 999) will return a valid result only
|
| Excel 2003 crashes when pasting table from Word 2003 | 08 Jan 2008 21:57 GMT | 1 |
've rolled out a new workstation image, and in the new image the users are now running Office 2003 SP3 (previously they were running SP2). Now when they try and copy and paste a table from Word to Excel, Excel immediately crashes. However if you do "paste special" and then ...
|
| Excel crashes when I try to change the font color | 08 Jan 2008 21:45 GMT | 4 |
Whenever I try to change the font color in Excel 2007 - the program shuts down. I have found others with this problem at http://help.lockergnome.com/office/Excel-2007-Error-Selecting-color-font-change- crash-ftopict1000328.html. This website explained the problem had to do with ...
|
| Possible Calcuation problem | 08 Jan 2008 17:32 GMT | 2 |
There is an Excel workbook stored on a shared drive on the server that behaves properly when all but one individual accesses it. When this person is using the workbook, none of the formulas will recalculate when changes are entered.
|
| Function quit working | 08 Jan 2008 16:28 GMT | 2 |
I have an excel form that I have used for over 2 years now. One of the cells has a sum function which adds 7 other cell values together. It stopped adding. I re-typed the formula into the cell and it added as it should. However, when I change a value in one of the 7 cells, ...
|
| Problem opening excel from shortcut | 08 Jan 2008 13:46 GMT | 2 |
When I attempt to open and excel program from a created shortcut the program appears to load with a blank blue screen with an unusual configuration at the top or excel will report the file doesn't exist. Closing out the window and hitting the shortcut again usually works, but not ...
|
| Trouble Opening MS Excel 2007 | 07 Jan 2008 22:02 GMT | 2 |
Something weird sometimes happens when I try to open MS Excel 2007. When I open Excel, the program opens, but it seems like it opens above my laptop screen. The status bar, with the Cell Mode, Macro Record, Zoom Slide, etc., appears at the very top of my screen when I run the ...
|
| File size 14mb opens to 150mb | 07 Jan 2008 20:13 GMT | 1 |
Help I have a 14mb xlsm which eventually opens to 150mb. I have tried everything I can to identify the problem, but can't. I have notice the following in the vba editor, the VBAProject for this file
|
| Excel Print Problem: When pages are scaled drawing move | 07 Jan 2008 19:56 GMT | 7 |
I wish I could attach a screenshot, a picture really is worth a thousand words... We have a few workbooks that contain drawing objects "on" certain rows, these worksheets are *scaled* to fit on to certain paper sizes.
|
| Arrays in Excel | 06 Jan 2008 23:43 GMT | 1 |
Using the =SUM(IF) array Excel can add an array with 2 and conditions such as (=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")'Batch Log'!F2:F2001,0)) but it cannot add an array with 3 conditions such as (=SUM(IF(('Batch Log'!A2 ...
|
| Help with Excel Formula | 06 Jan 2008 23:37 GMT | 3 |
What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch Log'!F2:F2001,0))
|
| error when exporting into excel | 06 Jan 2008 19:36 GMT | 3 |
I get this error when trying to export to excel. "Unable to open about:balnk.The internet site reports that a connection was established but the data is not available." Does anyone have any suggestions how to fix? thanks, april
|
| Excel making adding errors | 06 Jan 2008 14:14 GMT | 2 |
I just encountered something odd. I had 2 numbers in my excel sheet: "2690.33" (a typed in number) and 2690.33 (the result of a formula). I had a cell checking to see if these two numbers were equal and the result of that formula was FALSE! I expanded the result of the formula ...
|
| How do I delete a macro? | 06 Jan 2008 11:46 GMT | 2 |
I created a single macro in my workbook, just to see how it works, and then deleted it from the list of macros. The problem is, I still get the warning message "macros were disabled..." when I open my workbook all over again. Is there any other place where that macro is still ...
|