| Thread | Last Post | Replies |
|
| EXCEL ERRORS | 18 Dec 2004 11:21 GMT | 3 |
I have just installed Excel 2003 as part of the 2003 Offoce package, but when I start Excel, I get the following message: Compile Error in hidden module:AutoExecNew By clicking on it, the program seems to work normally.
|
| Comparing Fields in Different Columns | 18 Dec 2004 02:11 GMT | 1 |
I was wondering if there is a way two compare the fields in 2 different columns. Then if those fields are identical they would be removed. Is there a basic function to do this or do I need to write a macro? Thanks for the help.
|
| Pivot table for two different data variables | 17 Dec 2004 23:55 GMT | 2 |
I have the following table Name type Cost overhead amy C1 23 12 bob C2 129 17
|
| INFO: ON EXCEL SPREADSHEET FILE | 17 Dec 2004 23:49 GMT | 3 |
I am trying to open a paper clip in my incredimail, but it says I need EXCEL SPREADSHEET FILE.. I don't know what that is, therefore I don't know how to get it to open. PLEASE HELP ME ! Thanks.
|
| Opening and Excel spreadsheet in IE | 17 Dec 2004 23:44 GMT | 4 |
I have a user who is trying to open a spreadsheet in IE. She clicks on the link and it comes up with a "page cannot be displayed error". I am able to open the spreadsheet just fine. The user is able to save the spreadsheet to her desktop and open it that way and also, if she already ...
|
| Extracting Last Name and First Initial | 17 Dec 2004 23:24 GMT | 4 |
I need to extract the Last Name and the First Initial of a person's full name. The person's full name is written in this format: Last Name, First Name. Example:
|
| collating information from multiple sources | 17 Dec 2004 23:16 GMT | 1 |
Apologies if this has been asked before, but I'm a bit of a newbie when it comes to mucking around in excel, I've had a search but I don't really know what to call what I want to do, so finding the answer is tricky...
|
| Comments | 17 Dec 2004 23:15 GMT | 3 |
When a new comment is created, the comment window opens up with the user name in bold. Can anyone tell me if it is possible to set a default so that it doesn't display the user name? I have to delete it every time and it's a bit of a pain....
|
| New Date on each new page | 17 Dec 2004 22:57 GMT | 3 |
I would like to print a page for each day for the upcoming year. 365 pages. I want to print all of them now. On each page I need the date for that day. What should I use for this? Pivot tables??
|
| excel workbook | 17 Dec 2004 22:37 GMT | 2 |
I want to know why there are blank lines after the 1300 lines I imported? I want the spreadsheet to just cut off at , lets say, 1310 lines. How would that be accomplished? I would also like the just have cells A thru H and no cells to the right of
|
| Checkbox not part of cell. (???) Cells can move "underneath". (!!!) | 17 Dec 2004 21:01 GMT | 2 |
When I add a checkbox form to my spreadsheet, it is not part of any cell. It sits above the spreadsheet and can even overlap the row/column/cell boundary lines. When I place them so that they look like they're "within" the cell,
|
| Open workbook to a specific sheet | 17 Dec 2004 20:21 GMT | 5 |
What form of filename and switches will allow me to call a workbook and open it to a specific worksheet and, if possible, a specific cell. I've tried the following without success: "C:\Program Files\Microsoft Office\Office\EXCEL.EXE"
|
| Pivot Chart problems | 17 Dec 2004 20:11 GMT | 6 |
I have two issues with pivot charts. 1) I create a pivot table and chart with VB. I want thick lines on the chart, so I do as follows: For i = 1 To .SeriesCollection.Count .SeriesCollection(i).Select
|
| Newbie needs macro help Excel 2000 | 17 Dec 2004 19:37 GMT | 5 |
I need a little bit of assistance in creating a macro in Excel 2000, pc platform. I would like the macro to ask for a beginning number and an ending number. The macro would then populate the corresponding number of rows in column A
|
| How to get #value! to return a value of 0? | 17 Dec 2004 19:27 GMT | 4 |
My formula is like this: =A2+B2+C2. However, some of the values in the B2 column are "--," indicating "not applicable". When I use the formula, it interprets this as text, of course, and returns the error value of #VALUE! I want it to treat these as zeroes. How can I do ...
|