| Thread | Last Post | Replies |
|
| How do I get Office 2007 to show me the full path of a file? | 28 Mar 2007 18:37 GMT | 2 |
In previous versions of Microsoft Office you could have the name of the current file and it's full path appear at the top of the screen. Now, with Office 2007 all I can get is the file name. How do I get it to show the full path?
|
| Saving As .CSV | 28 Mar 2007 18:10 GMT | 9 |
Hello, here's the situation: I downloaded an .xls file from my broker and opened it in Excel. The original file was delimited by commas and I had to choose comma delimited in order for Excel to display it in columns/rows correctly. I made some changes to the file, then saved it ...
|
| Cond. Formatting Trouble | 28 Mar 2007 16:45 GMT | 1 |
I have a spreadsheet with cells that have conditional formatting to turn a certain color based on the input value. Its been working fine, until the last few times it has not changed the color of the cell until I close and reopen the sheet. Why might this be?
|
| image send to bak | 28 Mar 2007 16:26 GMT | 1 |
i inset a picture in my sheet and i can not see the cell i want see the cells and put this picture back of the cells what must i do thanks
|
| Rows of data, using status columns to sort data to pie chart on another worksheet tab | 28 Mar 2007 16:05 GMT | 1 |
1. I have 50 rows of data. There are many columns, but, there is one status column that I use to group the rows of data into relationships. I would like to build individual charts based on the status column. So, if I say these items are part of "Group A",
|
| Show Excel in two separate instances/two monitors? | 28 Mar 2007 15:49 GMT | 10 |
I've recently been upgraded to two monitors (one of the few things IT has done right around here!). But try as I might, I can't get two Excel (2003) workbooks to show in two separate instances so I can put one on each monitor! Any solutions?
|
| Which is faster sum(if) as an array or sumproduct? | 28 Mar 2007 15:28 GMT | 3 |
I finally got my sum(if) based on more than one condition to work but it takes my 1.8 Ghz chip 7 or 10 minutes to calculate the workbook with the array formulas in 2003 Excel. Is Sumproduct any faster or do I just need to use the free time to do something else?
|
| Sensitivity analysis | 28 Mar 2007 15:26 GMT | 1 |
I have a worksheet calcuating some results driven by different parameters. Is there a way I can tabulated (probably in a separate worksheet) the different results against different tuples of parameter automatically or easily?
|
| charts | 28 Mar 2007 14:54 GMT | 2 |
What is the best chart to show how much a different person used each year. Each person represent a different house I want to show which house used the most services for the year. So in excel I have a list of the people and the services they used on specific dates and the amount ...
|
| Silly question? | 28 Mar 2007 13:30 GMT | 5 |
Silly question? Just as one can sort a range up or down by this or that column, can one sort a range this way or that way by this or that row? I see no way of doing this but need to sort a schedule in this way as part
|
| Calculating number of weeks between dates (start and end dates) | 28 Mar 2007 13:13 GMT | 1 |
Two things I would like to do and I presume that Excel is the software to do it: 1. Ability to calculate the number of weeks between two dates. For example how many weeks betweeen April 2, 2007 and August 31, 2007.
|
| Grouping and Protection | 28 Mar 2007 13:09 GMT | 1 |
I need to use grouping on a spreadsheet (Excel 2003). Having designed the spreadsheet which uses grouping I then want to protect it but in doing so it stops users showing and hiding the groups. I have tried variuos options within the protect sheet dialog box but to no
|
| How to copy a Macro to another PC | 28 Mar 2007 12:56 GMT | 1 |
How can I find and copy an Excel macro to another PC. As I recall the one I created also created a file called Personal.xls that automatically opens up. Not sure if this is the only file that needs to be copied? Also, where does it get copied to? What location? Same as ...
|
| test if data fits between two columns | 28 Mar 2007 09:41 GMT | 9 |
have a table that I insert measured data into. Based on the value of the measured data, a formula returns a value in an adjacent cell. Usualy this would be easy for me just using a simple IF function But my method creates too many ifs and I get an error:
|
| copy reference number | 28 Mar 2007 04:34 GMT | 2 |
I have created a large spreadsheet Some 30000 Items I wsh to add a field for MYREference number at the end of each line for example badtimes1 then I would like to be able to automatically copy
|