| Thread | Last Post | Replies |
|
| Excel tabs keep disappearing and my worksheet pages view changes | 01 Sep 2007 00:54 GMT | 3 |
HELP! I am having trouble with my Excel worksheets lately. The sheet tabs will disappear for no apparent reason. I have reset the scrollbar size which sometimes temporarily fixes the issue. Also, The "Exit" X, minimize - and maximize box have all disappeared from the top right ...
|
| How to modify the code for different type of input? | 01 Sep 2007 00:30 GMT | 2 |
Does anyone have any suggestions on how to modify following code? I would like to set a formula to determine the value in cell A1 rather than manually type any value in this cell. In this case, if I set a formula to return a value in cell A1, such as, in cell A1, =A2+A3, when I ...
|
| Head to head | 31 Aug 2007 23:26 GMT | 3 |
I'm trying to statistically capture head-to-head occurences in a sports league. Out of 120 teams, I want to capture only 35 of those teams and how many times there is a head-to-head occurence within that pool of 35. I know the schedule will show something like "Team1 vs
|
| Is Multi click Event possible? | 31 Aug 2007 22:42 GMT | 6 |
I have 17 CommandButtons, "Browse..." on a form. Each one of them is suppose to open the FileOpen Dialog at a specific folder After selecting a file, the file is to be assign to the TextBox corresponding to each button
|
| JUST A SIMPLE DATE PLEASE! | 31 Aug 2007 22:40 GMT | 3 |
In Excel 2007 I need to have the date read as follows in several columns and it keeps appearing as a five digit number instead!! Pls help! Example: I need Jan 1 to read 01/01 in the column Thanks!
|
| personal workbook | 31 Aug 2007 22:39 GMT | 8 |
I don't know if I have my personal.xls workbook set up right. There was no Excel File in my office directory. There are several files called office with a number. One of them looked like Excel so I created an Office folder and created a workbook called personal.xls.
|
| column 2 to transpose using column 1 as reference | 31 Aug 2007 22:34 GMT | 2 |
Hello... please help with solution. col1 col2 col1 col2 col3 col4 1001 1001 to 1001 1001 1002 1003 1001 1002 1004 1004 1005 1006
|
| Sorting (Numbers with Text) | 31 Aug 2007 22:30 GMT | 8 |
I have a list of distances, that when I pull into a Pivot Table it sorts them by the "spelling" of the number, I have tried changing the type of field (Number, General, Text, etc). Nothing seems to work. Any suggestions? 0-5 miles
|
| Copy/Insert rows | 31 Aug 2007 22:28 GMT | 2 |
I am copying rows and inserting them further down the sheet. Trouble is, I can only select and copy 10 rows before Excel claims it's out of "resources". That's a bit annoying since I need to copy 200 rows - repeatedly. Is there a way to free up "resources" so that I could, copy, ...
|
| Can't Filter in Excel 2003 | 31 Aug 2007 22:28 GMT | 2 |
I am opening a file that opens in Internet Explorer as an Microsoft Excel spreadsheet. I have microsoft excel 2003 installed on my machine. When I try and choose Data-Filter, this option is greyed out and I can't filter my data. However, if I save the spreadsheet and then open ...
|
| Formula displays in cell | 31 Aug 2007 22:16 GMT | 2 |
I am writing a multi-step formula, once I get to a certain point I loose the calculation in the cell and the formula is displayed. How do I keep this from happening? The formula is : =$D$3*(VLOOKUP(G51,Territory,2,FALSE))*VLOOKUP(A47,CLASS,2,FALSE)*G3
|
| Excel add-ins | 31 Aug 2007 22:08 GMT | 4 |
I had an add-in already installed on my computer. An updated version came out and I installed it. When I leave and re-enter excel, the add-in does not automatically load. I can load it from the folder where it was stored, but I have to manually do this every time. In the ...
|
| Pop up timer for excel | 31 Aug 2007 22:08 GMT | 1 |
Is there a Pop up clock like the Pop up calendar for Excel? It would be best if it had date and time on one. Thanks, Jay
|
| Excel File Size | 31 Aug 2007 21:20 GMT | 1 |
Dear All; im facing a strange problem since 6 months a go, I created an excel file its size 600KB. after some modification i took after a long time today i need to modify the excel file its size raised to 32 MB. I scan file with Anti-virus
|
| Excel VBA Chart TickLabels | 31 Aug 2007 21:02 GMT | 6 |
Hello I have a chart on my workbook. I am trying to format the TickLabels values to Produce Letters instead on numbers, it only changes two numbers. and then give a error
|