| Thread | Last Post | Replies |
|
| OLAP Cube | 30 Oct 2006 20:19 GMT | 1 |
It will be a great help if any one can suggest me how to build a OLAP cube from excel sheet?Any documentation will be a great help
|
| Compile Error | 30 Oct 2006 18:26 GMT | 1 |
I am currently using Excel 2002. I was given a file, apparently created in Excel 2003. When I try to access the file I get the following message: Compile error: Can't find project or library
|
| type in one sheet and appear on all sheets | 30 Oct 2006 17:55 GMT | 7 |
I have an excel spreadsheet that i use for work and it has 6 different pages. Some of the pages have the same information as the first page. How can i get the info from the first page to appear on all the other pages without typing it into every page? I have tried to do the = on ...
|
| Duration problem | 30 Oct 2006 17:26 GMT | 3 |
Recently to avoid cd buying duplication i started to create a excel database of my audio cd collection , artist, track,cd name, duration of each track etc. I am now about half the way through my cd database and have just started
|
| make exel open at the bottom of the worksheet | 30 Oct 2006 16:21 GMT | 1 |
I have a problem. Every time I open a worksheet excel it starts me off at A86. I need to know how I can make it open and start me off in the first empty colum
|
| Macro security setting not stored | 30 Oct 2006 14:16 GMT | 2 |
my macro security setting is LOW by default. Whenever I try to change it, the new setting seems not to be stored, because afterwards it's LOW again. I'm running Excel 2003 SP2, but the same problem occurs in Word 2003
|
| New to Replan!! | 30 Oct 2006 10:45 GMT | 1 |
I have several spreadsheet xls files that have links to each other and it is now apparent that working would be much easier if they were all on separate tabs within the same spreadsheet file. (Appol's if the terminology is not quite right here).
|
| Workspace limited? | 30 Oct 2006 09:43 GMT | 3 |
I have a excel document where i can select cells to collom K. Now i want to change data in collom M. If i turn the sheet protection of (the password protection) i still don`t get i the area i want. Does anybody know how i can solve this?
|
| [1/1] - "SAMPLE.xls" yEnc (0/1) | 30 Oct 2006 09:40 GMT | 5 |
Newby looking for help. Trying to format spreadsheet so that data entered in ENTRY worksheet can be dispursed to sheets 1,2,3. Have the workbook working now with MAIN worksheet but data entry ungainly as ultimately there will be 40 to 50 sales people.
|
| uk lotto dream numbers | 29 Oct 2006 18:51 GMT | 8 |
hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G$4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1st 4
|
| Lists in a cell | 29 Oct 2006 17:41 GMT | 2 |
I need to put a list of names in a cell. It is cumbersome to use spaces to get to the next line. Is there a way that I can hit enter(or some other function) to move to a next line within the same cell. Thanks
|
| Sales Figures and performance - 1 attachment | 29 Oct 2006 17:39 GMT | 1 |
Newby looking for help. Trying to format spreadsheet so that data entered in ENTRY worksheet can be dispursed to sheets 1,2,3. Have the workbook working now with MAIN worksheet but data entry ungainly
|
| Sales figures and Performance - 1 attachment | 29 Oct 2006 17:37 GMT | 1 |
Newby looking for help. Trying to format spreadsheet so that data entered in ENTRY worksheet can be dispursed to sheets 1,2,3. Have the workbook working now with MAIN worksheet but data entry ungainly
|
| Add on mouse click | 29 Oct 2006 12:55 GMT | 3 |
Does anyone know a way to make Excel add a value to a total when the mouse clicks on an object? I am trying to make a scoring table for PowerPoint. I can embed the table, but no luck with the function.
 Signature Marshall
|
| Occurances of items in a range. | 29 Oct 2006 11:57 GMT | 3 |
I have a large field of data about 17,000 rows. What I want to do it break it into increments of 500 and then have excel count the occurances of each increment and in another cell total it. Please, for purposes of your responses assume all original data is in sheet
|