| Thread | Last Post | Replies |
|
| Excel DNS query | 05 Jul 2006 18:06 GMT | 2 |
Is there a way for an Excel function to query a DNS server? Thanks. Soundy
|
| Retrieve multiple dates, from a week number? | 05 Jul 2006 17:05 GMT | 1 |
I'm really new to excel and this forum, so please bear with me... What I'm looking to do, is having one "week-sheet" and one sheet for every workday, and having each of them updated with their correspondent dates.
|
| spreadsheet capacity | 05 Jul 2006 17:01 GMT | 1 |
Sorry for this very basic question: what is the max capacity for data points (in cells, by row and column of an excel spreadsheet? any help on this would be greatly appreciated.
|
| !Lost password! | 05 Jul 2006 16:53 GMT | 5 |
Hiya, My sister created a password on an excel spreadsheet that is very important 2 me, and she cant remember it, now I can only read the sheet and I can't modify it.
|
| converting dates to decimal years | 05 Jul 2006 15:35 GMT | 5 |
i need to convert dates dd/mm/yyyy to decimal years yy.yyyy but cannot find an example of how this can be done. i would be grateful for help? thanks
|
| Efficiently Generate 88 New Chart Sheets | 05 Jul 2006 14:45 GMT | 3 |
Gang, I've got a simple X*Y chart with year (1977-present) on the x-axis and an estimate of deer population size on the y-axis (actually, there may ultimately be 2 estimates/series). There is nothing really all that
|
| Formulas still too bulky | 05 Jul 2006 14:18 GMT | 1 |
Gang, Some time back I posted to the group my frustration with complex cell formulas. Many in the group helped with ideas. I'm writing this note because I still think there must be a better way. Below is my latest
|
| how can I have a formula result based on multiple criteria/columns | 05 Jul 2006 13:45 GMT | 1 |
I have an expenses sheet set up as follows: A/status B/date C/expense type D/amount 1 allowed 05/07/06 car £20.00 2 notallowed 05/07/06 car £450.00
|
| Finding records based on combo box | 05 Jul 2006 13:09 GMT | 1 |
I have a spreadsheet in Excel 2003, which has approximately 600 records (or rows). There are a number of values for each record, such as elecment code description and group.
|
| Working with Pivot Tables in a shared workbook | 05 Jul 2006 12:55 GMT | 4 |
I have a workbook that has a load of pivot tables in it. When I share the workbook I can't use the pivot tables anymore. Please would someone tell me why, and how do I get around this. I need to be able to share this spreadsheet so that other users can make use of the pivot ...
|
| locked cells | 05 Jul 2006 10:32 GMT | 6 |
I have excel 2000, and have locked some cells on sheets to safeguard my formulas whilst others are unlocked as they have weekly figures put in up until Sunday. On Monday, a clean sheets starts again so I have to go and delete all the entries on all the unlocked cells.
|
| why can't I divide number with time value? | 05 Jul 2006 09:28 GMT | 5 |
I'm trying to make a little sheet that counts for example points / hour. I calculate spent time as "ending time - starting time". And now when I'm trying to divide my "points" with this with time spent excel gives
|
| Dynamic Hyperlinking ? | 05 Jul 2006 09:12 GMT | 1 |
I need to burn some files ( Word,PPTs,PDFs, etc) onto a CD. These are referenced using hyperlinks in excel. Is there a way to maintain the hyperlink while burning the CD, so that the hypelinks still work while on the the CD ??
|
| Macro example | 05 Jul 2006 08:49 GMT | 1 |
Can I get an example of a recorded macro that is useful which can't be achieved by a copy/paste? Thanks
|
| Opening warning | 05 Jul 2006 08:15 GMT | 3 |
When I begin using EXCEL a message pops up warning that a file could not be found. It is from a program that I had deleted and I think is no longer on my PC. Is there a method to check and/or a method to delete the message? Thanks, Mike
|