| Thread | Last Post | Replies |
|
| the unprotect sheet is not highlighted | 20 Apr 2007 18:24 GMT | 1 |
I protected a set of worksheet in a work book and now I need to "unprotect" them but the "unprotect sheet" is not highlighted. Please help
 Signature confused
|
| Auto-numbering in Excel | 20 Apr 2007 17:30 GMT | 4 |
can i continue a number a sequence from one worksheet to another?
|
| File History Limitation | 20 Apr 2007 16:23 GMT | 2 |
Other Office apps can hold up to 9 the most recent files worked on. How can I change Excel to show a history of more than 4 documents? Bill
|
| If no value found in vLookup, I need to return a NULL to the Cell | 20 Apr 2007 16:11 GMT | 2 |
I'm trying to setup a Lookup Table and if the value is not found, I need it to return Null. The closest I can seem to get is it is returning #NA. How do I get around this? Example: Formula in cell C1 is =vLookup(A1,G:H,2,False)
|
| How can I sort out data? | 20 Apr 2007 16:10 GMT | 2 |
I have done an auto filter. Then, I cannot find some information in the drop down box, although it is there. The info. has been sorted out AtoZ. But the box only shows the information starting with A and B. However, I have input many words starting with other letters. And ...
|
| open already opened file | 20 Apr 2007 16:08 GMT | 1 |
I have some VBA-code that opens an Excel-workbook. But when that workbook is already open, I want this action to be aborted and set my workbook variable to the existing opened workbook. Anyone know how to do this? Kind regards,
|
| Calculate next year | 20 Apr 2007 16:02 GMT | 6 |
I have a sheet, in which Col A contains the list of month from Jan- Dec. I have to list down the month along with its year based on the month selected from the list in col A. So if Apr is selected then, in col B2 to B13 i have should have
|
| hide formula | 20 Apr 2007 13:58 GMT | 2 |
is there something I can do to hide my formulas from the end user in Excel? My formulas are sometimes 3 lines long and cover the data in my sheets. This workbook is located on a network, used over a few dozen computers so disabling it in the Excel options is out of the question.
|
| Export Chart to jpeg | 20 Apr 2007 13:02 GMT | 11 |
I am using MS Excel 2007, and want to export the chart to jpeg file, but i am not able to locate the functionality, Can anyone give some clues for it :)) cheers
|
| using now() as static function | 20 Apr 2007 12:15 GMT | 4 |
Experts I am preparing excel worksheet. I have developed macro in that sheet. The purpose of that macro is " When programmer finishes programming, runs macro using shortut key. The result is that particular cell changes colour to
|
| rounding in excel tables to add months | 20 Apr 2007 11:28 GMT | 3 |
We have a table that we are adding years and months such as 5.1 is equal to 5 years and 1 month. What we want to have happend is excel to stop the rounding and add the months like months with a base of 12 not 10. We have tried, int, rounding, changing formats, precise ...
|
| How do insert a watermark in an excel worksheet | 20 Apr 2007 11:00 GMT | 1 |
I am preparing draft financial statements in Excel and i want them to have a watermark that says "Draft" on each page when i print them
|
| How do I add commas after each text in each cell? | 20 Apr 2007 04:04 GMT | 2 |
I have a list of about 23,000 emails. I need to make an E-mail blast. The only way I know how to do that is by adding a comma at the end of each one. How can I save the hassle of inserting a comma manually into each cell?
|
| Macro to Refresh External data | 20 Apr 2007 02:32 GMT | 1 |
Good afternoon, I try to record a macro to refresh external data but the macro recorder does not give me anything once I refresh the query and stop the recording. Does anyone knows why?
|
| Email attachments | 20 Apr 2007 02:00 GMT | 1 |
I am new to sending email attachments and I am having a problem. I am trying to email an Excel spreadsheet (one sheet) as an attachment. When I open the email and print it out, it takes 3 sheets of paper to print out one 8 1/2 x 11 sheet. How can I fix this? Thanks in advance ...
|