| Thread | Last Post | Replies |
|
| Excel files open in a blank window. | 28 May 2008 20:47 GMT | 1 |
I just upgraded to office 2007. When I open an existing file, Excel opens up a blank window. If I go to File > Open, and hit cancel... the file will then open. I can also right click on the empty window, and select "Calculate Now" and that will also bring up the spreadsheets ...
|
| List of CommandBars & Control IDs | 28 May 2008 20:45 GMT | 5 |
Hi Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button
|
| countif, range and criteria | 28 May 2008 20:35 GMT | 9 |
I have a set range but now I would like to narrow that down by using two criteria. I used one criteria before but now I have two. Any advice is greatly appreciated. Thanks.
|
| Formula for time, possible? | 28 May 2008 20:25 GMT | 6 |
Enter "s" to record B C D call # timestamp timestamp 1 s 1:34:29 PM
|
| Help with Hr. Min formula | 28 May 2008 20:20 GMT | 2 |
I need to show a certin time (1Hr 30 Mins) in Cell D3 as a negative amount so that as time is inserted in other cells C4 to C10 the total at the bottom of the sheet D12 will take into account D3 Cell D3 is formatted Custom [hr]:mm and i am using Excel 2003
|
| Worksheet row limitations. | 28 May 2008 19:57 GMT | 2 |
When I attempt to paste data in excess of 65,000 lines to an new blank Excel 2007 worksheet I get the message "files not loaded completely" with an explanation that the file contains more than 1,046, 576 rows..., In fact the file I am trying to paste does not have anywhere near ...
|
| Macro if and / or statement | 28 May 2008 19:47 GMT | 3 |
I am having difficulty writing a macro with the if and /or together. Column C will be = "GOOD" if B is different than "VOY" and A is iqual to London and Cambridge. A B C
|
| Calculating an interpolation | 28 May 2008 19:38 GMT | 1 |
I am using Excel 2007, and I have an interesting issue... I have a column of numbers: 0, 500, 1000, 2000, 4000, 6000 and 8000 feet The next column are calculated formulae for takeoff distances for the
|
| How do I create 5 Conditional Formatting rules in Excel 2003? | 28 May 2008 19:37 GMT | 2 |
Excel 2003 allows only 3 rules for Conditional Formatting. I need to use 5 rules, though.
|
| In Excel I type 24E1 in a cell it changes ... | 28 May 2008 19:31 GMT | 6 |
even when I put the formatting as General. No matter what it keeps going back to Scientific format afterwards. Help? This is a branch code I need in this spreadsheet for import into a HRIS system.
|
| Name stays, everything else scrollable. | 28 May 2008 18:22 GMT | 3 |
I have a speadsheet document that has a list of names on it that go in column. Each name has specific data to it that goes in the row. However there is alot of data to each name and so when i scroll to the right i no longer can see the name. I would like to keep the names there ...
|
| Multiple files opened when Excel started | 28 May 2008 18:20 GMT | 2 |
After a collegue set up my Excel 2002 to show multiple files at one time, every time I start Excel it tries to open all kinds of files - including PowerPoint and Word docs, so I end up with dozens of error messages and about 20 Excel files opened every time I start the program. ...
|
| Picture popup | 28 May 2008 18:17 GMT | 2 |
In Excel, What will the code be to display a picture on the screen if button is pressed? I have a button, if pressed, needs to open a MsgBox or somethin displaying a picture.
|
| Increase number of items shown in drop down list? | 28 May 2008 18:11 GMT | 2 |
I'm using Excel 2003 and want help adding items to an existing drop down list.
|
| Macro & "personal" sheet annoying! | 28 May 2008 17:51 GMT | 2 |
Everytime I open excel program, a sheet named "Personal" automatically opens. I think this is happening since I have used macro feature once before. Could anybody help this sheet not to open? Thanks.
|