| Thread | Last Post | Replies |
|
| WebData Substitute | 06 Mar 2008 15:04 GMT | 2 |
Folks: Excel 2007 has an add-on called WebData. Essentially it can use any web page as a data source and download content to the spreadsheet. * Is there any software program out there than can be used to perform the
|
| excel changes my figures | 06 Mar 2008 14:53 GMT | 1 |
hi I tryed to inpit this info into a chart 0.008199 6.3 0.0151625 6.8 0.006469 7.5
|
| SORTING BETWEEN WORKSHEETS | 06 Mar 2008 14:37 GMT | 11 |
I HAVE THREE COLUMN ON SHEET1 NAMED AND LOOK LIKE THE BELOW: A1 B1 C1 NAME START END A 9 AM 5 PM
|
| Round up or down to a multiple of 5 | 06 Mar 2008 13:45 GMT | 5 |
I have a question. Im trying to come up with a formula that should say: the total of a whole number times 1.15 and then round it off to either a 0 or a 5. Can someone please help me!
|
| Can I mark a point on curve? | 06 Mar 2008 07:45 GMT | 1 |
I want to mark a point in curve of chart. it is possible?
|
| Data Validation against table list | 06 Mar 2008 05:27 GMT | 1 |
Hi, I've got some Excel tables in a spreadsheet and I'd like to add data validation to some other cells so that only those values in the table can be chosen. I know how to do that where the list of choices comes from a named range, but Excel won't let me refer to the table
|
| display changing label caption on form as sub runs w/o screen flic | 06 Mar 2008 03:02 GMT | 1 |
let's say i have this routine Sub Test label1.caption = "Starting ... " 'do events
|
| Autofilling formulas when I insert a row | 05 Mar 2008 23:26 GMT | 2 |
I've got a rather complex Excel 2007 spreadsheet that others are going to be editing, and when they insert rows I would like to have the columns with formulas in them fill down to the new row. I know there's a setting in Options to Extend Date Range Formats and
|
| trouble getting a formula to repeat rows | 05 Mar 2008 22:39 GMT | 5 |
Thanks in advance to all your help. I have a formula I'm using, =(C1*3)+(E1*5)+(F1*3)+(I1*5)+K1, and I need it to repeat at the end of every row and recalculate every row, so that every row has its own total. Trouble is, when I copy the formula from the Formula
|
| Poor performance in Excel 2007 | 05 Mar 2008 22:27 GMT | 7 |
I am facing a very poor performance in Excel 2007. Some files I have (around 2.5 Mb each one) take almost 1 minute to open/close in Excel 2007, while in Excel 2002 the same files take no more than 2-3 seconds. Any idea?
|
| Excel 2007 File type conversion | 05 Mar 2008 21:32 GMT | 1 |
Is there a way to convert a work sheet to an xml document? Thanks in advance
|
| COUNTA formula with indirect reference - help please! | 05 Mar 2008 19:46 GMT | 7 |
Hi-- I am getting strange results with a formula. I would like to use COUNTA to count non blanks in a worksheet called "Data". I'd like it to take column values from cells C2 and D2 to get the range of data in
|
| I type a word in a cell, tab out and it changes | 05 Mar 2008 19:38 GMT | 1 |
For our invoicing we use the same worksheet every time, we just type in the new information, print the invoice off and so on. I came back into work today and now when I type a certain word in any cell, as soon as I tab out of that cell another word appears. I cannot figure out ...
|
| counting nonblank rows | 05 Mar 2008 18:46 GMT | 8 |
I'm trying to figure out how to integrate the number of nonblank rows within a given array into my formula. I have tried COUNTA(ROWS(C6:Z29),1), but that does not give the correct result. Any help that you all may offer would be greatly appreciated.
|
| Excel 2007: Flaky Macro | 05 Mar 2008 18:35 GMT | 2 |
I've got a weird situation with a macro that I'm not sure how to go about debugging. This is all within Excel 2007. From time to time (i.e., not always), the macro fails at a point where I first load a workbook and then immediately save it as an Excel 2003 file. And it fails by ...
|