| Thread | Last Post | Replies |
|
| Excel 2007 - Cannot print from Open > Tools > Print | 15 Feb 2008 19:34 GMT | 2 |
On Windows XP SP2 using Excel 2007 I am unable to print from the Open file dialogue. Here is what I am doing: Clicking Open from the Office button
|
| New Email Message | 15 Feb 2008 18:19 GMT | 1 |
All - how do I get a workbook selection into a new email message. I need the new email window to pop up (with excel selection) and have the user add their own comments and adressees. Thank you.
|
| Is there a formula for "last" | 15 Feb 2008 18:08 GMT | 2 |
I have a lookup cell that compares today's value with that of a week ago. But sometimes (like on weekends) the today value doesn't change. Is there a formula for "last"? i.e., instead of TODAY() is there a LAST() formula?
|
| Start up error | 15 Feb 2008 16:53 GMT | 4 |
I just did a complete reinstall of my OS and all software. I reinstalled MSoffice and now whenever I start Excel I get the following error Microsoft Visual basic:
|
| Filtering Data by Number Range | 15 Feb 2008 16:49 GMT | 1 |
I have a worksheet that looks similar to this Company Name Data Company1 1 Company1 5
|
| Multiple Worksheets formula - Help | 15 Feb 2008 15:57 GMT | 2 |
Excel 2003 on XP I have a file that contains nearly one hundred worksheets. Each Worksheet has been renamed with the city location it relates to. All the worksheets are exactly the same.
|
| Macros | 15 Feb 2008 15:30 GMT | 3 |
I currently have a workbook that has 10 worksheets. Nine of the 10 worksheets are brought in from another application. The 10th worksheet is added at the beginning as a summary worksheet for the other 9. At this time someone has created a macro to look in column H of ...
|
| Problem linking to a cell with a date. | 15 Feb 2008 15:17 GMT | 1 |
I want to link a summary spreadsheet with multiple project spreadsheets and one of the cells i'm linking to is a cell with the "TODAY()" function but it is actually two cells that I have merged together... so say D4 and D5.
|
| Active Column Ref in a Formula | 15 Feb 2008 15:12 GMT | 2 |
The formula in a cell sums accross a row from a fixed column to the column containing the formula How do I have a variable which represents the active column? Thank you
|
| Faster way of linking multiple cells between spreadsheets? | 15 Feb 2008 15:05 GMT | 1 |
I have a spreadsheet for each on-going projects and one summary spreadsheet. Each time I create a spreadsheet for a new project, I have to go back and forth between the new spreadsheet and my summary spreadsheet and
|
| How to group days in a pivot table, but to include field header days for which no entries are found (see example) | 15 Feb 2008 14:51 GMT | 3 |
I have a pivot table that groups data by day (as a field header) like this: 1/1/08 1/2/08 1/3/08 1/5/08 1/6/08 Category 1 10 20 22 23 etc
|
| When I reference a cell in a separate list, I am unable to sort that list and keep the reference. Any suggested solutions? | 15 Feb 2008 14:32 GMT | 2 |
I have noticed that when I reference a cell (eg, in worksheet 1) from a list (eg, in Worksheet 2) in another spreadsheet, and then sort the list (in Worksheet 2), that I lose me reference (in worksheet 1). Does anyone know how I can alter the reference, or user settings so that I
|
| Pivot Table - Simultaneous Drill-Down | 15 Feb 2008 14:25 GMT | 1 |
In a Excel Pivot Table, when we double-click a cell in the Data area, a new sheet is created with the details. What I want to do (I already did it in the past), is when I click a cell in the Row area, several sheets are created (one per value).
|
| alphabetize within a cell | 15 Feb 2008 13:27 GMT | 13 |
if i have a list of letters in a cell, is it possible to alphabetize them? example: ADCB --> ABCD
|
| PLEASE HELP OFFSET / HLOOKUP / MATCH I HAVE READ OTHER POSTS | 15 Feb 2008 13:18 GMT | 2 |
I have looked at loads of other posts around this but I can't get any of the examples to fix this. I have the following problem: I have a date which I would like to use as a reference to lookup
|