| Thread | Last Post | Replies |
|
| configuration window at start | 17 Nov 2007 13:42 GMT | 1 |
I have Office 2007 with Windows XP. Whenever I start Excel, the configuration window starts and goes through the setup process. I let it run through many times, but the window comes up again and again. I removed and re-installed Excel with no cure.
|
| minimum function but want to exclude zero | 17 Nov 2007 12:56 GMT | 2 |
I have a quotation form I use which has several supplier values in a column. I want to calculate the minimum value but because every supplier does not always give a quote their value will show zero. In short I want the minimum in the
|
| Excel 2003 - VBA - Importing .txt files and unwanted Names | 17 Nov 2007 12:43 GMT | 1 |
I have a spread sheet that I use VBA to import other files. I re-import every day to keep the sheet up-to-date. In general I identify areas of the spread sheet with names and access them that way. I have noticed that when I import a file, it creates a NAME in the spread sheet as is ...
|
| Can it be done in excel? | 17 Nov 2007 12:20 GMT | 8 |
Does anyone have any suggestions on how to do this trick in excel? Within the cell A1, B1, C1, when I enter a number in one of three cell, such as 3 in cell A1, then 3 will be automatically display on cell B1 and C1. On the next step, if I enter 6 in cell B1, then 6 will be ...
|
| Tracking Time in my Spreadsheet | 17 Nov 2007 11:46 GMT | 4 |
Would someone be so kind to advise me of the formular required to track the hours passed between two dates/time? i.e Start Date and Time = 01/01/07 @ 06:00 hrs
|
| pivot tables | 17 Nov 2007 11:38 GMT | 2 |
I have data on an excel spread sheet a workbook which I would like to use to populate a pivot table in a different work book.is this possible or does the pivot table need to be in the same work book?
|
| I forget the password of protecting sheet, I need to unprotect it | 17 Nov 2007 09:55 GMT | 1 |
That sheet has hidden columns and I need to unhide them because they contain formulas which I forget them as well. The sheet is protected with a password. Is there any way to recall the password or even view the formulas? Thanks
|
| Template WANTED | 17 Nov 2007 09:49 GMT | 5 |
Looking for a simple 'personal investment portfolio template', where one can list their mutual funds and stocks, with columns across for number of shares, share value, total value. Seems simple, but I don't know Excel so cannot do one myself.
|
| Help with sorting blanks out of a list | 17 Nov 2007 07:53 GMT | 3 |
In Excel 2007, I have a list of names, addresses, county, phone number and email addresses. Not every name has an email address. So if I sort the list into just county and email address Im left with ALOT of blank cells where there were no email addresses. Ive done a sort by ...
|
| How do break the link from my excel workbook to a access database. | 17 Nov 2007 06:26 GMT | 4 |
The access database my excel workbook is trying to link to no longer exists. Yet each time I open the lworkbook I receive a message to enable or disable automatic refresh. How do I unlink and how do I shut off the prompting for refresh?
|
| Any Excel spreadsheets to track a Wolf scouts achievements? | 17 Nov 2007 05:40 GMT | 6 |
My wife has used an excel spreadsheet (that somebody else set up) to track the achievements for the tiger cub scout den that she is leading. We were wondering if anybody has or knows of a similar spreadsheet for the Wolf cub scouts.
|
| Printing Double-Sided | 17 Nov 2007 05:12 GMT | 2 |
I am trying to do double sided printing in excel with multiple worksheets (>20). In order to print double-sided, I need to (within Excel) select File -> Print -> Properties and select "Flip on long side" in order to adjust one worksheet. Excel does not change the printing ...
|
| Solver Ignores Constraints | 17 Nov 2007 04:30 GMT | 1 |
Does anyone know exactly how/when Solver uses the parameter constraints? When I ask Solver to find the value of x for which f(x)=0 subject to the constraints that x>=L and x<=U, I always assumed that Solver would never try to evaluate f(x) at values of x outside of the interval ...
|
| Stop Values Duplicating | 17 Nov 2007 04:13 GMT | 3 |
I have an excel spread sheet into which serial numbers are input. However a serial number can be duplicated, how can i stop this from happening.
|
| How to average every 48 rows of data for 20,000 rows? | 17 Nov 2007 03:03 GMT | 7 |
Hi. I have a huge spreadsheet (~20,000 rows). I need to average every 48 rows into one value. Is there a quick and easy way to do this without scrolling through all 20,000 rows and copy-pasting the "average" function every 48th row?
|