| Thread | Last Post | Replies |
|
| Auto Close | 16 Jun 2005 20:03 GMT | 5 |
Is it possible for an activesheet to close after 10 minutes of idleness?Reason is if a user forgot to close his file, it will automatically close down. thanks
|
| Saving Excel format from web based application | 16 Jun 2005 19:17 GMT | 1 |
Hi all....my question involves exporting excel spreadsheets from a Web application and having them saving in Excel 97-2002 format. Currently the spreadsheets save as "Microsoft Excel Spreadsheet" and are not compatible with Access 2002. I have to open the spreadsheets and then
|
| Add function | 16 Jun 2005 19:09 GMT | 2 |
Hi. I want to know how can I do to add a function for use like Max() or Min()
|
| Protecting Structure of cells | 16 Jun 2005 18:52 GMT | 1 |
Hi, I need to protect the structure of an Excel sheet so that unexperienced users can enter data but cannot change the structure of the document such as the width, height, font size etc?
|
| Format from function | 16 Jun 2005 18:51 GMT | 2 |
I want my function to format the cell it is coming from. E.g. Function testfunc() application.caller.font.name="arial" End Function
|
| Formula to fill inthe Quarter | 16 Jun 2005 17:53 GMT | 7 |
I seem to always have trouble when dealing with dates in Excel. Is it possible to have a formula the would look at the date field and fill in the quarter in col 1? Dates 01/01/02 - 03/31/02 = Qtr1 and so forth.
|
| Keyboard shortcut to formula bar? | 16 Jun 2005 17:49 GMT | 2 |
Is there a keyboard shortcut to the formula bar? If yes what is it? I would like the cursor to go to the right of the content of the cell I'm in when I use the keyboard shortcut.
|
| =IF(B3<O;nodisplay(graphA);display(graphA)) | 16 Jun 2005 16:46 GMT | 2 |
I have a sheet with numbers and graphs. If the number of the cell B3 is lower than zero, I wish that Graph A, do not display. Is it possible to manage this ?
|
| one column to three | 16 Jun 2005 16:45 GMT | 5 |
I have one column of data which goes, name; address; tel; every 3 rows. I want to split it into 3 columns (one for each field). My first thought was to somehow use paste special, transpose - but I cant figure out a way to do it.
|
| web form | 16 Jun 2005 16:44 GMT | 1 |
I have a form that I'd like to post to my website. It's an order form. I want the User to be able to go to the form, fill it in, and print it out. I also want the information that the User fills in saved into some type of database on my server...either excel or access...it doesn't ...
|
| how to print receipts from excell | 16 Jun 2005 16:21 GMT | 7 |
I need to print receipts from excel, but I need the information to be placed in specific location on the receipt: Name........ Amount........
|
| Excel Training Material? | 16 Jun 2005 16:10 GMT | 2 |
I have been asked to deliver some Excel training. Whilst having a reasonably sound knowledge of Excel, I would like to offer a professional course and wondered if anyone could point me in the direction of some good quality learning material?
|
| Mail Merge directory v2003 | 16 Jun 2005 16:06 GMT | 2 |
In version 2003, when I click on the Mail Merge button, it opens to an inconvenient directory. Is there a setting anywhere to change the location that opens up when I click this button? Please let me know how to change this setting. TIA!
|
| Format Question | 16 Jun 2005 15:31 GMT | 3 |
Hello! I am trying to set cell A5 = A1 + A2. The problem that I encounter is Cell A1 is all text and Cell A2 is a Julian Date that I converted to form of 5/1/2005. When I try to set Cell A5 = A1+A2 I lose the Date Formatting and Cell
|
| excel as a repository | 16 Jun 2005 15:28 GMT | 19 |
why is it that people use excel for a repository? i mean-- Access was used to store data-- Excel doesn't have the basics for storing data. i mean-- why do people use Excel EVER?
|