| Thread | Last Post | Replies |
|
| Adding Values Across Spreadsheets | 04 Jan 2005 16:49 GMT | 4 |
Having done about all the Googling a boy can take, I am still unable to find out how to do this, so I figured I would ask your goodselves. I have a workbook with a number of pages. Each page represents the formulation of a particular product. There is also a page that acts as
|
| Calculate age | 04 Jan 2005 16:45 GMT | 2 |
I need a function to calculate the age of a person starting on birthday. Thank you Luis Jorge
|
| TEMPLATE IN EXCEL FOR MONTHLY PAYMENTS FOR MORE THAN ONE PROP | 04 Jan 2005 16:20 GMT | 1 |
Am first time user of excel and would like to organize this project. how do i do this?
|
| Maximum Row Count | 04 Jan 2005 16:19 GMT | 4 |
Apparently, Excel 2000 has a limit of 65,536 rows? Can someone post maximum row limits for Excel XP and Excel 2003?
 Signature Peace & happy computing,
|
| Seeking advice on how to print a price list | 04 Jan 2005 13:22 GMT | 2 |
I am trying to produce a price list from a large Excel spreadsheet - it comes down to roughly 10000 items on three columns - I'd do it in Excel but want to get three columns to the page but don't want to manually format each page (the previous version was in this format and
|
| excel 2003 ... setting up "Look In " within "open" | 04 Jan 2005 13:09 GMT | 2 |
How do I set the default directory when using the file "OPEN" facility? At the moment when I use ,,File> open ,,, the default directory in the "look in " box is "my documents",, I would like to change this deafult to the excel folder within my documents.
|
| spreadsheet addiction | 04 Jan 2005 12:48 GMT | 9 |
There is a new page on the Burns Statistics website http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html that looks at spreadsheets from a quality assurance perspective. It looks at several specific problems with Excel, including the
|
| Returning the last item in column | 04 Jan 2005 11:21 GMT | 3 |
I'm stumped by something that seems simple. I have a column of data that is added to each day. I want to take the last value in this column each day and enter in a daily summary row. My summary row contains sums and averages for other columns, but I just need the last value in ...
|
| save excel file to xml | 04 Jan 2005 05:21 GMT | 1 |
how can I save a excel file to xml? Thanks, qq
|
| list box coding question | 04 Jan 2005 04:48 GMT | 2 |
I have a quick question regarding populating a list or combo box based on certain criteria from another combo box. (if this is at all possible with excel..hehe). What I am looking for is the following: On one sheet I have a combo box. On the same sheet I would like to have
|
| Auto Scaling in charts | 04 Jan 2005 03:20 GMT | 3 |
is there a method of clearing font scaling in charts by default (as opposed to chart-by-chart basis)
|
| Pivot table- Calculated Field | 04 Jan 2005 02:57 GMT | 2 |
Please assist I want to show the % difference for the last dates entered. item # 12/12/04 12/13/04 %Change item1 100 110 9.1%
|
| Locking rows across multiple sheets | 03 Jan 2005 23:31 GMT | 2 |
I'm using Excel 2003 and am having a problem locking rows across multiple sheets. For example, I have two separate sheets in the same workbook to track client jobs. Sheet 1 contains job status by job while sheet 2 contains additional related job information by month. Column
|
| How do you make a backup file - .bak or MS equivalent? | 03 Jan 2005 23:13 GMT | 4 |
I have been using Lotus. When you SAVE AS you are given the choice to make a BAK (backup) file. Is there a similiar command in Excel? When I use SAVE AS it just asks if I want to replace. Thanks for any help.
|
| Call & Place Graphic Based on Cell Value? | 03 Jan 2005 23:12 GMT | 1 |
Is there any way to call & place a graphic image based upon a cell value?
|