| Thread | Last Post | Replies |
|
| auto save freature | 02 Jul 2007 01:33 GMT | 1 |
We are experinceing some difficulties with our use of the Excel program. we use it to enter data in such a manner as to use it as scheduling program. Several workbooks used as months, with mutiple worksheets for days. Two main issues, one: we are unable to cut and paste from ...
|
| Why this anamoly? | 01 Jul 2007 21:39 GMT | 3 |
While defining constants it does/does not matter whether you precede the value by an "=", still it works. Suppose the name is "Rate" and in Refers To box, you type either 12.5 or =12.5 both work. Why this anamoly? Thanks
|
| v lookup | 01 Jul 2007 18:05 GMT | 6 |
please help with instructions for dummies using v lookup. I have data from row 130 to 8000 and across 48 colums. I need all the columns data to be picked up. I have row 2 to 129 that I want the data to end up in. I enter in b2
|
| Pivot Table - Change Data source | 01 Jul 2007 17:48 GMT | 4 |
Can I change to data source to an existing pivot table or do I have to start over? I currently use a spreadsheet as the data source. It was made from a MS Access query and I'd now like to make the query the data source.
|
| excel has encountered an error and must close | 01 Jul 2007 16:37 GMT | 2 |
excel 03 xp pro I am having a problem with all of office but there is not a general office group. Every time i open an excel file i get a message excel has
|
| Formulas between workbooks | 01 Jul 2007 13:12 GMT | 2 |
I have financial year data from July 1 06 to June 30 07 in one workbook and have started another workbook, today, July 1st, with the months July07 through to June 08. I used the same formula as I did in the original. I made a name in Name Manager and told it the value =SUM(June08 ...
|
| Disable keyboard shortcuts | 01 Jul 2007 12:23 GMT | 21 |
I use some keyboard shortcuts that are global to Windows, e.g. Ctrl+; to generate the letter "ö". This does not work in Excel because Ctrl+; inserts the current date. Is there a way to disable such inbuilt shortcuts in Excel 2003, either
|
| word count | 01 Jul 2007 09:50 GMT | 1 |
Is there anyway to get a word count or character count like Word does?
|
| AVERAGE help, Excel 2003 | 01 Jul 2007 07:42 GMT | 6 |
I have an Excel problem again. This time, it's with AVERAGE. My project is faculty evaluations and I have spreadsheet listing the rating areas in column A, stopping every few rows with a formula for the average on the area, such as teaching skills, communication skills,
|
| Load Excel into Access Database - Connectivity Problem. | 01 Jul 2007 03:18 GMT | 1 |
How can I set up connectivity from an Excel Worksheet to an access database? Would like to load a worksheet into an access database using the Docmd.TransferSpreadsheet. However, I'm getting that I don't have the database open.
|
| How can I change commision % after it pass certian number | 01 Jul 2007 03:07 GMT | 1 |
i have class project where i am suppose to be sales manger and i am trying to set up a pay plan for sale personals, the gross profit percentage changes "20%" after the 12 sale the plan retroactive and go up to 25%. i am trying to think if there is plan that changes the commission ...
|
| Pivot tables merging data on two sheets (Office 2007) | 01 Jul 2007 01:12 GMT | 1 |
I have invoices sent on one worksheet and payments received on another. I'd like to do a Pivot table which would be capable of doing a summary of what each account owes.
|
| where to get Access drivers for Excel? | 01 Jul 2007 01:05 GMT | 1 |
I am working on importing Access databases into Excel (learning) and I need the drivers for importing data. Where to find them? Thanks
|