| Thread | Last Post | Replies |
|
| 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.
|
| Help with VBA | 28 May 2008 17:35 GMT | 3 |
Is there any good, free, sites to help understand the basics of Excel VBA
|
| Conditional Formatting | 28 May 2008 17:32 GMT | 4 |
Is it possible to apply a conditional formatting in cases where each value in column P exceeds the adjacent value in column D. I have several hundred rows and would like to do this without visiting each individual cell in column P.
|
| Debug on userform | 28 May 2008 17:00 GMT | 1 |
I have an option button on a user form that changes a selected cell to either say "true" or "false" depending on which option button is selected. I keep randomly getting a debug error. To correct it I just hit end and refresh my user form and everything is fine again. Any idea ...
|
| Excel 2007 GetPivotData Function | 28 May 2008 17:00 GMT | 2 |
In Excel 2007, I'm using the GetPivotData function to get data to one sheet from company data on another sheet. Sometimes a company is missing, and then I get #REF! in the GetPivotData cell. Is there a way to incorporate the GetPivotData function in an IF function, or some ...
|
| calculate a particular date | 28 May 2008 16:57 GMT | 3 |
I have a row of different date when people joined a study. I need to calculate the exact date three months afterwards. How do I create a formular, so I don't have to calculate it separately for each different person(given that thye joined on different dates?
|
| Printing on large paper | 28 May 2008 16:57 GMT | 2 |
I am working on a very wide spreadsheet, even shrinking to 50% it is 30 inches wide and I have to paste the pages together. I want to take the file to a Printing co. to have them print directly onto large paper, say 8.5 x 30. How can I set the page set up or paper size for this? ...
|
| Help excluding some info from counta formula | 28 May 2008 16:50 GMT | 4 |
I have a column that includes a check mark symbol or N/A. I'd like the checkmarks to in each section to add together and populate another worksheet with the number of checkmarks in each column.
|
| Excel problems after winXP sp3 update | 28 May 2008 16:25 GMT | 4 |
After I updated my copy of WinXP Pro with sp3, I began experiencing a series of problems that seem to be related to running Excel, in that they only occur when Excel is open. These problems include: delayed screen refreshes, slower performance, occasional system freezes, ...
|
| Convert list to table | 28 May 2008 16:09 GMT | 1 |
I'm in trouble! I have a list of data I have to transform in a table and I don't know how to do it. I'll be extra clear: I have an excel table formatted this way:
|
| vlookup for more than 2 range | 28 May 2008 15:59 GMT | 6 |
dear i have a database in 2 sheet, and i want to use vlookup in 3rd sheet, pls help its urgent. regards
|
| Vacation accrual Spreadsheet | 28 May 2008 15:40 GMT | 6 |
I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary.
|