| Thread | Last Post | Replies |
|
| open 2000 files with 2003 | 27 Dec 2007 20:41 GMT | 4 |
We are networking between 2 computers. Some files were created on Comp1 with Excel 2000 and I'm trying to open and edit them on Comp2 with Excel 2003. How do I do this? I can view the file name, but it just doesn't open
|
| Creates new file when opening in windows explorer | 27 Dec 2007 20:23 GMT | 4 |
I have a user that has a wierd problem. When she selects an excel file in Windows Explorer and opens it, it creates a duplicate file with number 1 at the end. For example, if the file is called aplogs.xls, when you open it, the file name is aplogs1. The user is getting macro ...
|
| how to unhide multiple rows in one go? | 27 Dec 2007 20:06 GMT | 2 |
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do I unhide all the rows in one work sheet in one go without having to drag them out individually?
|
| League age chart | 27 Dec 2007 19:19 GMT | 4 |
I have a large number of youth base ball players listed in a roster; Player name birth date john doe 3/5/2001 mike smith 7/31/2001...
|
| urgent help with lock excel macros!!! | 27 Dec 2007 19:13 GMT | 8 |
Hi to everyone, I was looking for a way to make Excel like viewer. Surfing in the news group I found this macro. It works to lock Excel but now I can't unlock Excel back!!
|
| Help! Missing information!! | 27 Dec 2007 18:41 GMT | 8 |
Greetings, Excel Community. I hope you can help me with this one. I was typing some notes in an Excel Spreadsheet, which made for some really jam-packed cells. However, when I came back to look over it, half my information was gone, cut short at the 1.5 line mark. Is there ...
|
| Can I restore yesterday's file? | 27 Dec 2007 18:29 GMT | 4 |
I accidentally replace an latest excel file to an old file... Can I restore yesterday's file? Is there anywhere I can find that file again? :( Please Please help... Urgent! Thank u so much
|
| Excel 2003 - VBA - Charts | 27 Dec 2007 18:26 GMT | 1 |
I am beginning an effort using VBA to create a custom chart to show data over a period of time for a select client. I realize this is going to be a long row to hoe but I need the results that the efforts will provide. I have done quite a bit of work with charting under VBA, but ...
|
| Continuous data in a histogram | 27 Dec 2007 18:18 GMT | 1 |
I have continuous data and wish to get a histogram where the bars touch eachother, due to the fact that in continuous data this has to occur. However, when I have constructed a histogram the bars don't touch eachother. Can anyone tell me how i can get the bars to touch eachother ...
|
| Excel 2007 File Size | 27 Dec 2007 18:18 GMT | 1 |
I am currently working on an issue with Excel 2007. I open a file that was previously made with Excel 2003 and was only 1.7 MB but when I opened the file in Excel 2007 and clicked save the files size jumped to 2.43 MB. Now that I have done that when I try to open the file it ...
|
| Excel 97 Find and Replace | 27 Dec 2007 17:58 GMT | 1 |
Have the following issue: Column of telephone numbers are listed as follows: ### ####### Is there a way using find and replace to delete the space between the
|
| Sumproduct Help | 27 Dec 2007 17:36 GMT | 2 |
=SUMPRODUCT(--('Consolidated Exp'!$E$2:$E$5000=C$9),--('Consolidated Exp'!$K$2:$K$5000=("I")),'Consolidated Exp'!$F$2:$F$5000) coulum E = Month, coulum K = Type of expense
|
| Pivot table Calculated Field | 27 Dec 2007 17:35 GMT | 1 |
I have a column of Salesmen together with an associated column of their sales. Let's say that the total of all the sales is £100,000. I would like to insert a calculated field that shows the % contribution that each salesman makes to the total sales.
|
| Pivot tables - All Change with Validation List | 27 Dec 2007 17:33 GMT | 1 |
I have an Excel workbook with several sheets in it. I have the following sheets: Summary Totals
|
| countif formula: 2nd column qualifier | 27 Dec 2007 17:21 GMT | 6 |
In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help?
|