| Thread | Last Post | Replies |
|
| Problem Opening Excel 2003 Documents | 21 Mar 2008 20:59 GMT | 1 |
I am using Excel 2007, but to make sure that anyone with an older version of Excel is able to use it, I save as Excel 97-2003. Recently, one particular spreadsheet has stopped opening on Excel 2003, even though it works just fine on computers that have Excel 2007. I am still ...
|
| How do I print the spreadsheet and show formulas instead of values | 21 Mar 2008 19:23 GMT | 2 |
I'm trying to back into a complicated spreadsheet that someone else created, instead of clicking on every cell, I'd like to just print the spreadsheet with the formulas showing instead of the value. HELP!
|
| Getting no results from Advanced Filtering in Excel 2007 | 21 Mar 2008 18:29 GMT | 1 |
I'm attempting to use the advanced filtering in Excel 2007 but the filtered list is identical to the unfiltered list though I have tried various critieria. I followed the Help guide meticulously, but get no apparent results. What am I missing? Is there something not ...
|
| why would 57 column by 40 row excel spreadsheet be 5216k? | 21 Mar 2008 18:06 GMT | 1 |
I copied data from a website to a spreadsheet (Office 2003), ended up with 57 columns and 40 rows, no pictures or micros, just numbers, but the spreadsheet is 5216k, which seems very unreasonable and is excessive for both my XP desktop and my Vista 64 laptop, both with 2 G ram. ...
|
| military time "if" formula | 21 Mar 2008 17:57 GMT | 9 |
i have employees sign-in and sign-out using military time. I want to be able to calculate if each employee was present at a certain hour. For example: Sign-in: 8:00 Sign-out: 14:00
|
| Require specific cell entry before saving file | 21 Mar 2008 17:46 GMT | 1 |
I want to require the user to enter his/her name in a specific cell (E59) before the user can save the file. I tried using Data Validation where I specified Text Length between 1 and 40, and left blank the check-box for "Ignore Blank". Nope. I never
|
| Finding the Access query a pivot table is based on | 21 Mar 2008 17:13 GMT | 1 |
I took over some reporting from someone else who created pivot tables based on some access queries. All I need to do is to refresh the pivot table to get updated data. I want to find out which query in my access database the pivot table is using but cannot seem to locate this. ...
|
| Excel 2003 - A string of #s needs to be separated into individual | 21 Mar 2008 17:05 GMT | 3 |
I have a string of number in one cell separated by semicolons. How does I get Excel to place each number in an individual cells? Is there a way to use the "Find and Replace" option to do this. the string looks like: 1;2;3;4;5;6;7 i'd like 1 to be in a cell 2 to be in a ...
|
| I need a spreadsheet column showing time in 30 sec. intervals | 21 Mar 2008 16:04 GMT | 2 |
How do you develop a spreadsheet showing a column with 30 second intervals over a day without having to enter each time individually?
|
| Data validation formulas | 21 Mar 2008 15:24 GMT | 1 |
I'm trying to understand data validation using custom formulas. What I don't get is how to apply validation rules to a range using a custom formula that validates a cell based on the value in that cell. The specific problem is how to reference the individual cell.
|
| Excel 2007 Graphs - Series Formating | 21 Mar 2008 15:05 GMT | 1 |
I am creating a scatter graph from a Pivot Table sheet of values and while all points from 4 separate series are correctly plotted, when I select a particular series to create a least-squares line, not all points of the series appear selected. When I select one of the points ...
|
| Excel 2003 vs Excel 2007 | 21 Mar 2008 15:01 GMT | 2 |
How do I??? I was an extensive user of the "LIST" functionality under the DATA heading in Excel 2003. Does Excel 2007 have the same functionality? I can copy files from Excel 2003 into Excel 2007 and the list function works but I do
|
| Experimenting with (offset in VBA) | 21 Mar 2008 14:44 GMT | 4 |
What I'm trying to change a heading on sheet 1 and print the page- the "variable" heading information is in column A on sheet 3 and the first time that is comes to a blank - end the loop. If print fine the first time and then it gives me a Run-time error '13" on the Loop Until ...
|
| My office 2007 live preview function is not working. Know why?? | 21 Mar 2008 14:39 GMT | 2 |
My live preview is not working. Does anyone have a clue why this is? Thanks
|
| 2003 formulas crash 2007 | 21 Mar 2008 14:17 GMT | 1 |
Any help or suggestions would be appreciated. I am wondering if anyone notices why this would be working in 2003 and not in 2007. I have a scheduling spreadsheet that works beautifully in Excel 2003 and will not calculate in 2007. I can only work in the file with all
|