| Thread | Last Post | Replies |
|
| How do you add three ending '0's to a column of numbers? | 29 Aug 2007 16:56 GMT | 1 |
I am pretty sure I've Done this before but it does not work under the custom format feature which what I thought I had used. Seems som simple, huh? thanks, s
|
| Task Pain | 29 Aug 2007 16:44 GMT | 4 |
Hi. Whenever Excel 2003 is opened, it shows a task pane on the right hand of the screen. Is there any method to disable it so that it does not open each time Excel is opened?
|
| Previously viewed docs | 29 Aug 2007 16:39 GMT | 1 |
How do I get more than 4 previously viewed docs in the file menu?
|
| ThisWorkbook of personal.xls | 29 Aug 2007 16:28 GMT | 4 |
When I have in ThisWorkbook of personal.xls the code below without the last sub (the Private Sub xlApp_SheetSelectionChange), all functions well. But when the last sub is added I have problems with copying because when I try to copy data, the items paste and past special of the ...
|
| SAVING A FILE TO DISC | 29 Aug 2007 16:28 GMT | 3 |
I WANT TO COPY AN EXCEL FILE TO DISC TO SEND TO A CUSTOMER. I WANT THIS TO BE PROTECTED SO THE CUSTOMER CANNOT CHANGE ANY INFORMATION, BUT I DON'T WANT MY ORIGINAL FILE TO BE PROTECTED. CAN I DO THIS SO IT IS ONLY PROTECTED ON THE DISC?
|
| Office 2007 Colors | 29 Aug 2007 16:16 GMT | 1 |
I have spreadsheet that I created in Excel 2003. It is used by many different people. I now have Office 2007 and I have been asked to make a number of changes and additions to the current spreadsheet. The original colors from 2003 don't seem to be available in 2007. When I save ...
|
| How come the spreadsheet says calc when it is set to autocalc | 29 Aug 2007 16:16 GMT | 1 |
In the bottom left the word calculate is always there regardless if calc is set to auto or manual. It is in ato now, is there a problem?
|
| Excel 2007 | 29 Aug 2007 15:57 GMT | 3 |
I'm looking for a dbase file converter for Excel 2007
|
| "Sort" in Excel 2007 disabled--why? | 29 Aug 2007 15:44 GMT | 3 |
I have two columns that I want to sort. Unfortunately, stupid Excel 2007 has "Sort & Filter" on the "Home" ribbon, and everything on the "Data" ribbon disabled. Why can't I sort? And why on earth did Microsoft move everything around. Nothing works like it
|
| In EXCEL, can a cell have two values? | 29 Aug 2007 15:40 GMT | 1 |
I would like to have a cell to have two values. For example, if a person uses the resources of an institution on two different days but for a different club on each occasion, is there a way to represent this in a table without having to insert another column?
|
| pdf to excel files | 29 Aug 2007 15:38 GMT | 2 |
how do I convert pdf files to an excel file?
|
| When open document, want date to be current automatically. How? | 29 Aug 2007 15:34 GMT | 5 |
I want the date to show current date automatically when the document is opened. I have a document in Word that does this but I do not know how it was done.
|
| #N/A outcomes in formulas | 29 Aug 2007 15:33 GMT | 2 |
I am using a spreadsheet with multiple sheets and using the Vlookup formula to pull certain data from the sheets. The VLookups are working fine, but I then have to add a certain number of Vlookups together in one formula. Again, I believe they are working fine, but some of the ...
|
| Fill Blanks Macro | 29 Aug 2007 15:12 GMT | 2 |
I have a spreadsheet that has 44,383 rows. I am trying to use the following macro to fill in the blanks for columns A:D. I am getting a REF error. I know it is the number of rows because the macro works for spreadsheets that do not have as many rows. Is there any modification ...
|
| variable substitution in a formula linking to external workbook | 29 Aug 2007 15:05 GMT | 2 |
Hi, I'm trying to link to an external workbook. Let's say the formula is: G:\2007\2007 Jun\blah.xls I would like to be able to change "Jun" by referencing a cell. I've read
|