| Thread | Last Post | Replies |
|
| Raw Data | 18 Oct 2006 00:37 GMT | 2 |
i am new to microsoft excel. i want to practice pivot tables & charts etc Is there any site available from where i can download raw data and experiment with it to get more understanding on how excel works ?
|
| Critique of code | 18 Oct 2006 00:28 GMT | 23 |
I consider myself a dabbler in Word VBA and a begginer (is there anything less skilled than that :-)?) with Excel. With my technical level established, a user in the Word VBA groups asked how to populate a dropdown field in a Word document with data
|
| More on MAX | 18 Oct 2006 00:23 GMT | 4 |
In a column of data covering several years - e.g. the daily yield of the 30 year bond - finding the maximum yield figure in hundreds of entries would be laborious and subject to error; is there a way to get the cell identification using MAX? That is, the precise cell ID as in ...
|
| spreadsheet on the web | 18 Oct 2006 00:00 GMT | 2 |
I have a spreadsheet that I would like people in my group to be able to access, edit and save on the web. Is this possible? I'm not talking about downloading, editing and uploading. I'm talking about opening a file/spreadsheet on the web, putting some information on it, 'saving'
|
| Macro Protection | 17 Oct 2006 23:57 GMT | 2 |
Morning, I was wondering if someone could point me in the right direction. i'm on a unix box emulating Win NT Now here is the problem, I use several Excel spreadsheets that have macros
|
| Linking 2 files | 17 Oct 2006 23:55 GMT | 1 |
I got a file A with numbers and a file B with links to the first. If I insert new rows between 2 lines, the links in the other file don't change after i press recalculate. Is this normal? Who can help me?
|
| Why are some spread sheets so much larger? | 17 Oct 2006 23:54 GMT | 12 |
We receive one particular spread sheet from a client on a regular basis. Typically they range in size from 15K - 60K so they don't have much information in them. Some of them are over 3 meg in size and take a while to open. I can't see any additional data in the worksheets and ...
|
| What version of Excel converts Lotus 1-2-3 spreadsheets? | 17 Oct 2006 21:44 GMT | 1 |
I had a 30-day trial version of Microsoft Office (which I do not know what version it was) and purchased the Student 2003 Office which no longer converts Lotus 1-2-3 spreadsheets to the Excel spreadsheet. I'd like to upgrade and do not know which one to purchase.
|
| how do I copy and paste and have my gridlines show using excel? | 17 Oct 2006 21:15 GMT | 2 |
I am making a catalog using excel. I need to trasfer each page to my website. I am able to copy and paste and it shows my information, but there are no gridlines.
|
| Special Paste Dialogue Box | 17 Oct 2006 21:03 GMT | 4 |
I use the Special Paste options frequently. Is there a simiple way to open that dialogue box? Such as a hotkey combination or a way to add it to the right-click (mouse) menu? It is a pain to always have to mouse click "Edit" then "Special Paste..."
|
| appointment scheduler | 17 Oct 2006 20:57 GMT | 1 |
Is there an add-on or something for Excel that will notify you of up coming appointments or events? Bill
|
| Auto Fill - working as expected? | 17 Oct 2006 20:20 GMT | 1 |
My understanding of the auto fill was that Excel would search within the active cell's column for a match, then offer the fill. If there is a blank row between where I am typing and other entries, the auto fill does not work.
|
| Query on a text file..help needed | 17 Oct 2006 18:41 GMT | 1 |
I am trying to query a large text file and I'm beginning to wonder if it is just impossible to do. I used the excel query wizard but because I am working with a fixed length file I am not coming up with the columns I need. The wizard
|
| Excel formula | 17 Oct 2006 18:23 GMT | 1 |
I am using the formula - =COUNTIF(E913:E914,"COR") to count the number of times the word COR occurs in my document. I got the formula from Excel Help in the program. The problem is that it won't count, the answer is always zero even though COR appears several times in Column E. ...
|
| Unable to Edit MS Query | 17 Oct 2006 16:58 GMT | 1 |
I have an excel file that has multiple queries. Previously, I was able to edit these queries. Now when I try to edit the query I get no response. I am connecting to Oracle and have the necessary TNSNAMES.ORA file in place.
|