| Thread | Last Post | Replies |
|
| duplex printing excel charts | 19 Jun 2007 18:45 GMT | 1 |
I have a workbook with several charts on worksheets. I would like to print chart1 and chart2 on a single paper. My printer supports duplex printing. I select the 2 worksheets and print using duplex. I am getting 2 pieces of paper instead of 1. What am I doing wrong? thanks
|
| Drop-down lists in Excel 2003 | 19 Jun 2007 18:40 GMT | 3 |
I think I already know the answer to this, but I need independent verification to defend a decision I made. If you are validating a drop-down list from another Excel file, that file must be open, correct?
|
| Lists | 19 Jun 2007 18:39 GMT | 1 |
I need to setup a small table with 2 columns and maybe 10 to 15 rows. I want to be able to have a person access this info with either a list or drop down list so they can choose an item from the table and have it inserted into a cell.
|
| Summing certain criteria - Advanced | 19 Jun 2007 18:29 GMT | 6 |
What would be the best way to go about summing values based on certain criteria. I have many different spreadsheets that contain total customer payments and total company payments for a given customer. When the total customer payment for a given customer reaches a certain number ...
|
| Weekday question | 19 Jun 2007 18:22 GMT | 9 |
It seems Im having a problem with weekday function. I have a column of data values, some of those values are DATE function given and then there are some others in text format (even some blanks). Trough a macro i can identify which weekday is it, so to do an action
|
| Recover Back up files | 19 Jun 2007 18:02 GMT | 1 |
I finished working on a large file and went to save it when i got an error and Excel shut down on me. I went to the location where Excel saves the back up with the extension of .xlb and have tried to open it. All I get is a new work book and the file never opens. Is there a way ...
|
| Special selecting problem | 19 Jun 2007 18:01 GMT | 4 |
I have a worksheet that has project numbers in column A, dates in column B and events in column C, like: A B C 1 2007-06-17 Whatever
|
| How to change security format of spreadsheat? | 19 Jun 2007 17:45 GMT | 3 |
A former co-worker must have programmed Excel 2003 program in her computer to automatically have exclusive use only. Then she resigned and the new person doesn't know how to undo it. We have this Excel file from that computer that we need shared and to be edited by any user in ...
|
| correct order of months in pivot table | 19 Jun 2007 17:44 GMT | 6 |
My worksheet has dates in the "mmddyyyy" format with associated counts of procedures. I would like to present this in a pivot table with the counts broken down by months and formatted as "Jan, Feb, etc." How to do it?
|
| XML to Excel conversion issue | 19 Jun 2007 17:26 GMT | 1 |
Dear folks, I have generated XML file and its a table. I have given defination below.Now when i open this xml file is MS-EXCEL 2003 i get output like this
|
| Spin Buttons are too Slow For Use | 19 Jun 2007 17:16 GMT | 2 |
I've been trying to use spin buttons in a large workbook I've created but I've found that they take too long to use. I'm currently using them to increase or decrease a starting number by .005. Using the buttons in this manners requires 3 or 4 linked cells. I think this is why ...
|
| How can I make Excel recognize a time period | 19 Jun 2007 17:03 GMT | 3 |
I am building a shift schedule with 3 shifts of 8 hours each. (Days, Swings and Nights) Days shift works from 7am-3pm, swings 3pm-11pm and nights from 11pm-7am. At the bottom of each shifts, I am required to count how many employees working that day. In some instances, an ...
|
| Excel Help!! | 19 Jun 2007 16:50 GMT | 2 |
How can I change the tab but keep the row and column constant when filling in equations? I'm orgainizing a excel spreadsheet in which I have many sheets/tabs in. I'm trying to put a formula in on my main page where I can get the data from
|
| Excel worksheet only prints the first column - how do I fix? | 19 Jun 2007 16:36 GMT | 1 |
Vista as the operating system. Excel worksheet only prints the first column. Cannot get it to print the entire page even though the "print preview" shows it will print the entire selection.
|
| Shared Workbook - locked for editing | 19 Jun 2007 16:34 GMT | 2 |
I have a shared workbook that approximately 5 people use. Last week it started displaying the message that is locked for editing by a user and could only be opened in Read Only mode. The user listed is not using the shared workbook. In fact, if he tries to open the document now ...
|