| Thread | Last Post | Replies |
|
| weird behavior when checking check boxes | 20 Mar 2007 17:59 GMT | 1 |
I have a really weird problem. I have a excel file with about 20 sheets. on one, I have check boxes. about 10 when I check one box, the others grow in size.
|
| inserting a hard return with replace in a cell | 20 Mar 2007 17:31 GMT | 2 |
Is there a way to insert a hard return or line break using the replace function in a cell? Thanks brent
|
| formula fill not working correctly in 2007 | 20 Mar 2007 17:29 GMT | 4 |
If I use the fill handle to copy a formula, the formulas are well copied, but the results are not. Exemple: The formula in A3 is =A1+A2. If I copy the formula to B3 it reads =B1+B2, which is correct. The result given in B3 however is not B1+B2 but the same result as in A3. I have ...
|
| Pivot Tables and Trend Data | 20 Mar 2007 17:27 GMT | 2 |
I have a data table that lists products down Column A. Columns B through P have characteristics of each of those products. Beginning in Column Q are monthly numbers. That is, Column Q has month 1 numbers, Column R has month 2 numbers, etc.
|
| Importing text from an Explorer window | 20 Mar 2007 16:35 GMT | 4 |
Howdy all. OS: XP, Excel 2002 SP3 I have my music stored in the My Music directory. I have Artist, Album Title, etc. attributes turned on. What I'd like to do is to take all of this
|
| auto update of conditional macro | 20 Mar 2007 15:51 GMT | 7 |
Hi again, I have just noticed that when I open the spreadsheet the cell with the =today() command automatically updates but the macro that is dependant on the answer does not update.
|
| font color depends on a number | 20 Mar 2007 15:05 GMT | 4 |
I have a number in A1 :the font color=black If I place a "1" in B1 I want the font color in A1 to turn to RED and consequently place a "2" in B1 would return tje font color to black Please help & Thanks
|
| Help | 20 Mar 2007 14:48 GMT | 3 |
i have the following VBA running in a workbook and i have a problem when running 1. When i add another sheet to the workbook it will search the first worksheet and a message box will appear and the correct cell will be
|
| How do I get a column to appear along the horizontal axis of chart | 20 Mar 2007 12:28 GMT | 1 |
I have two adjacent numerical columns; when I select them to create a chart Excel chooses to plot both columns vertically side by side. Instead of that I want the left column to appear along the bottom of the chart and the right column to be vertical.
|
| Weird files | 20 Mar 2007 06:35 GMT | 5 |
Just noticed I've got a ton of weird files with names like 2BE48300. The normal files seem to be ok. Any idea what might be producing all these extra files?
|
| need surnames in a column in excel seperate from the first names | 20 Mar 2007 04:22 GMT | 2 |
If I have a column containing both first name and surnames, how do I get the surnames into another column?
|
| pivot tables | 20 Mar 2007 03:37 GMT | 6 |
Can't understand why it's so difficult to create a pivot table report. I've followed all the tutorials I could find on google-including Microsofts', none of them work for me. Isn't there a simple way? It's so easy with MS Works.
|
| File association oddity | 20 Mar 2007 03:05 GMT | 3 |
On my machine, I have both Office 2002 and 2003, which are loaded into different folders. Xls files I open from Windows Explorer open in Excel 2002. I changed the association to 2003, but something odd is now happening. Now, when I double-click an xls file from Windows
|
| Excel07: where did Draw Object Fill Patterns go? | 20 Mar 2007 02:11 GMT | 7 |
Did the ability to fill drawing object with patterns just go away? I see pictures and textures, but no patterns. Losing these is a big deal for things like engineering sketches and things that have to be faxed--where none of the textures, say, work at all well).
|
| Problem reading Excel 2003 file through OleDB | 19 Mar 2007 23:44 GMT | 1 |
Hy everybody, I've got a problem reading an Excel 2003 file in VB.NET. The problem comes when I do a SQL sentence through the Jet engine. If one column in the Excel file contains some numeric values and some string values, only returns
|