| Thread | Last Post | Replies |
|
| how do I remove dotted page break lines from my workbook pages? | 27 Aug 2007 11:44 GMT | 7 |
I have been maintaining an excel workbook for years - it is a log - that never gets printed. Suddenly, out of the blue, I have page break dotted lines on the pages/sheets. How do I get rid of them?
|
| Creating shortcuts for a database between two pages | 27 Aug 2007 11:22 GMT | 1 |
I'm not a pro at Excel, but I know this can be done (I had someone create something similar at work a couple years ago). I want to create a document for weight management. I have all the food items on a second spreadsheet with information such as protein, carbs,
|
| Number Formats | 27 Aug 2007 09:39 GMT | 2 |
2003 Excel - I have imported data into a file and want to create a lookup formulae that will return a description when matching two numbers. The numbers do not appear to be in the same format and therefore the lookup formulae is not working. I have tried changing formats but ...
|
| Worksheet acts like its protected but it's not | 27 Aug 2007 05:16 GMT | 1 |
hyperlink, sort, chart, etc. are all faded. Same in the pulldown menus. The worksheet is not protected nor is acess limited. I created this spreadsheet. It is very simple. I've never seen this problem before.
|
| Excel Protection | 27 Aug 2007 03:22 GMT | 2 |
I'm currently using an excel document, this spreadsheet has been password prtected and the creater is no longer around. Is there a way to copy the excel spreadsheet onto a new document and then remove the protection?
|
| COUNTIF | 27 Aug 2007 02:28 GMT | 6 |
I got a worksheet for each month of the year with a list of 300 names in column "C" and 300 ages in column "D" from 18 year old to 99 year old. I got a resut worksheet that will tell me how many 18,19,20...99 year old were contact in January, February...December.
|
| Slow Sumproduct | 26 Aug 2007 23:23 GMT | 1 |
I have a data entry sheet with 25 columns of data. The data is both text and numeric. I have 5 reports on separate worksheets in the same workbook. QUESTION: when I get 1000 or more lines of data, excel slows because each time I enter data in a cell, the cells recalculate. Can
|
| Absolute reference (F4 Key) not working | 26 Aug 2007 22:32 GMT | 4 |
i've just installed a new wireless microsoft keyboard and in excel it won't recongise me pushing f4 in the formula to change a cell reference to absolute???? but outside of the formula it lets me push it and opens a new workbook.....
|
| Corrupted Excel File | 26 Aug 2007 22:24 GMT | 1 |
I suddenly find myself with an important file that is corrupted. 1) Is there a way to recover it? 2) Is there a way to back up the date of the computer to a time before the file was corrupted?
|
| Cells locking after Protect/Unprotect | 26 Aug 2007 22:20 GMT | 2 |
I have a workbook with an 'entry' sheet for user input, which is protected. Several cells on the sheet are unlocked to allow user input, the rest have been locked. I also have several macros which change various parts of the sheet based on
|
| Saved an e-mail attachment in OLK4B after editing. Can't find it | 26 Aug 2007 21:52 GMT | 1 |
Someone sent me an e-mail with a spreadsheet as an attachment so I could edit it. I did edit it, and I clicked on Save As and on the drop down it had OLK4B. I didn't save it in My Documents. Now I cannot find it. Where is OLK4B? How can I retrieve this spreadsheet. Also, on a ...
|
| LEN? | 26 Aug 2007 21:17 GMT | 2 |
What is it? I have seen it referenced several times in formulas on this group, but what is it?
|
| combinations | 26 Aug 2007 20:26 GMT | 11 |
Hello, People! I am looking for a formula that will help me determine how many different outcome I will get. I have illusrtated below a simple format the way it will be layed out.
|
| Grouping Date Fields in Pivot Table | 26 Aug 2007 19:44 GMT | 2 |
I'm trying to summarise a member database using pivot tables in Excel 2003. My source data includes a field for date of joining (dd/mm/yyyy). I would like to create a pivot table showing YEAR of joining as a variable and I'm sure it's possible to group individual dates into ...
|
| Conditional formatting problem in Excel 12 / 2007 | 26 Aug 2007 19:36 GMT | 5 |
I'm having a problem with conditional formatting in an Excel 2007 pivot table. The spreadsheet has a calculated field column which is the % difference in revenue from one month to the next. After I select the cells in that column and make a new formatting rule for Icon Sets, the ...
|