| Thread | Last Post | Replies |
|
| Excel 2007 file open error | 17 Dec 2007 04:06 GMT | 1 |
Excel 2007 won't open an existing Excel file. Opens as jibberish symbols. Why? help!
|
| replace #N/A value in EXCEL by 0 ???? | 16 Dec 2007 06:18 GMT | 1 |
I'm using very large EXCEL Sheet for import of external data. After I make new calculations, which will be shown in the master-TAB. I receive many "#N/A" values of course, but I don't care about. I just like to make total calculation of the colums. But result of calculation for
|
| cant open file by double clicking - excel 2007 | 16 Dec 2007 03:02 GMT | 13 |
i cant open xls files by double clicking on them - excel open empty window without any error message. i try to do /unregserver /regserver , clean xlstart directory and wait about an hour with open empty window (i read that exclel 2007 can have lags with opening documents). file ...
|
| Excel is not highlighting cells | 14 Dec 2007 17:04 GMT | 1 |
When I use the ctrl button to highlight multiple cells there is no shading to the cells that I have clicked on. The column and row headers are showing that something is selected but not the cells. Is there a quick fix for this?
|
| #div/0 array | 13 Dec 2007 21:27 GMT | 1 |
I have read through all the post about #div/0 error when making a formula with average, but I cannot seem to get any of them to work? I've tried entering the array formula, pressing ctrl+ shift+ enter, but it just comes up with "the formular you have enteret contains an error"
|
| Basic Subtraction Error | 12 Dec 2007 22:04 GMT | 2 |
I am subtracting a few numbers and getting a tiny error in my result It is happening in multiple (but not all) places on my spread sheet. I don’t know if this is a bug in Excel or something else. This is an example of the error:
|
| Opening Excel 2003 file | 12 Dec 2007 17:58 GMT | 2 |
My file will not open if I click on the file as I normally would. I have to be in excel and go to the Open file icon and then go to the folder and open the file. It will always open that way. Can someone tell me what i need to do?
|
| Excel 2007 attachments don't display data. | 12 Dec 2007 15:42 GMT | 1 |
I migrated from Office 2003 to Office 2007 last week. Since the migration every time I open a Excel attachment from Outlook, Excel will open, but it will not display the data. If I click open and then cancel the window the data appears.
|
| Text is white in some cells | 11 Dec 2007 20:57 GMT | 2 |
I have created an Excel sheet for the recording of collected weather data but I am getting frustrated by the non appearance of data in just three cells. If I put in a background colour I can see the data in white so obviously the font has become set in these cells to white but ...
|
| Excel 2003: why won't my toolbar change stick? | 11 Dec 2007 19:58 GMT | 2 |
I've tried repeatedly to remove the Euro Conversion button/command off my toolbar (using Customization/Rearrange/Delete), but every time I open a spreadsheet, it's back. What can I do to make the change stick?
|
| create a formula | 10 Dec 2007 23:19 GMT | 2 |
Example: if H5-G5 equals a negative sum I want to show zero if H5-G5 equals a positive sum I want to show that sum Please help
|
| Data Analysis Toolpak Add-in Error | 10 Dec 2007 20:01 GMT | 1 |
When trying to install the Data Analysis Toolpak from the "Add-in" option in "Tools" I initially get no errors. However, the "Data Analysis" option does not appear in the toolbar. If I exit Excel and reopen it, the ANALYS32.XLL file opens as a read-only and give me the "This ...
|
| cannotshiftobjectsoffsheet appears when I insert columns , why? | 10 Dec 2007 19:52 GMT | 2 |
when I try to move a column by using "cut" and "insert cut cells" I get an error that says "cannot shift objects off sheet". I am not using all of the columns or rows in the worksheet so why do I get this error?
|
| Dates before 1900 | 10 Dec 2007 19:50 GMT | 1 |
I'm trying to get a very simple DATADIF formula to work. I subtracted the start date from the end date of each employee to get the total number of days they were employed. This works fine for dates after 1900, but anything from the 1700 or 1800's results in a value error. Is ...
|
| Hidden Module Problems | 10 Dec 2007 19:48 GMT | 5 |
I have recently experienced problems when I start and close excel. On strting the messdage refers to hidden module AutoExecNew and on closing it refers to DistMon.
|