| Thread | Last Post | Replies |
|
| Troubleshoot Excel 2002 formats | 29 Nov 2006 06:02 GMT | 1 |
I have a rather large spreadsheet using nearly all columns. It has many rows of data with text headings at the top of the data columns. (There are just a few rows above that for "report title" types of content.) Along the way, somehow Excel lost track of the formatting. ...
|
| Excel Error - "Avaliable Resources" | 29 Nov 2006 05:57 GMT | 1 |
I want to know how to correct for this error message: "Excel cannot complete this task with available resources. Choose less data or close other applications." I am using two spread sheets. with only a small amount of data - 20 Colums
|
| Excel Cell Data Entry | 29 Nov 2006 02:29 GMT | 3 |
I recently installed the tech refresh to B2, and now whenever I try to put something in a cell, even in a new Excel sheet, only one character can be entered. For example, if I enter a B it displays in the cell, then if I enter an X, the B is replaced by the X. I am running XP ...
|
| Error message when creating PivotTable | 28 Nov 2006 23:44 GMT | 1 |
I selected the range of data to use for the table, but when I go to the wizard and click "finish", I get the error message:The PivotTable name field is not valid. I made sure that the data are really neat, but that does not change anything!
|
| 2007 Converters | 28 Nov 2006 20:12 GMT | 1 |
I have several MISSION CRITICAL SPREADSHEETS on excel 07 and have been told that I cannot reload the beta. I downloaded the "converters" but the excel one does not work. How can I get to my data?
|
| "Unable to read file" after using SaveCopyAs | 28 Nov 2006 14:42 GMT | 5 |
I built a simple "backup" module within an existing Excel file. The backup module simply makes a copy of the open workbook using the SaveCopyAs method. The backup module runs fine. The problem is that after the SaveCopyAs method is run, I save and close the original workbook. ...
|
| MS Query crash in Excel 2000 | 27 Nov 2006 19:58 GMT | 4 |
I have a saved query that was created in MS Query. I use it to store the results in Excel 2000 (my employer's version, not my choice! v9.0.6926 SP-3). I could not use the Query Wizard to create it because the SQL was too complex. At least that's what the app told me. So I ...
|
| Run Time Error | 27 Nov 2006 19:22 GMT | 1 |
I have Excel 2003. Every time I open a page in excel, whether new or for editing, a Microsoft Visual Basic Run Time Error pops up that says: Method 'Add' of object "CommandBarControls' failed. I am no longer able to add any patterns to a page or change the font color whether I go ...
|
| Copy formula error | 26 Nov 2006 01:59 GMT | 2 |
I'm using Excel 2003: When I copy a formula from a cell over to the cell on the right, the formula copies correctly but it picks up the values in the row to the left. Then when I save the worksheet, the formula then gives me the correct SUM. Odd, very odd. Has anyone ran into ...
|
| Ocultando colunas | 26 Nov 2006 01:35 GMT | 2 |
Trabalho com uma planilha extensa (até a coluna HU) e tenho, por razões óbvias, diversos agrupamentos horizontais (estruturas de tópico). O problema é que sempre que tento "fechar" todos os grupos criados, o Excel não permite e mostra o seguinte diálogo: - "Não é possível deslocar ...
|
| I Enter $875.00 in a price sheet, it changes to 875 on print out | 24 Nov 2006 18:51 GMT | 1 |
I am working on new price sheets for my company and every time I try and enter $875.00 as the price for a part, it changes the total to read 875, it will not let me correct it. PLEASE HELP
|
| my pointer has turned into a black square | 22 Nov 2006 23:13 GMT | 1 |
When using excel and word my pointer has turned into a sold black square. Nothing I try gets it back to normal. Does this have something to do with my drivers? Can it be fixed pretty easy? Help this is annoying.
|
| sum corruption but mostly scrolling madly | 22 Nov 2006 01:56 GMT | 2 |
I cannot work inside the excel file - it somehow is on a sum mode where it scrolls madly down the sheet higlighting everything but not doing anything. Seems to be in a calculation mode - not letting me enter or key anything & the only way i can get out is to shut down the ...
|
| Cursor locks on cells and won't release as if in auto fill mode? | 21 Nov 2006 20:32 GMT | 2 |
My cursor in excel locks on a cell and won't release itself. As I move the mouse the cursor moves but holds the anchor cell and also covers the adjoining cells as though its in an auto fill or copy mode. The only way I can release the cursor and stop the autofill cell copy like ...
|
| Replace dot to comma using a macro doesn't work!!! | 21 Nov 2006 11:20 GMT | 2 |
I'm getting nut's at this... Have a workbook wich is picking up external data (currency) from a website. It gives me the values with a dot in them (i.e. 12.345) That's not usable when I want to convert the currency to another one since
|