| Thread | Last Post | Replies |
|
| Excel title bar | 04 Oct 2007 20:26 GMT | 3 |
I have big excel spread sheet, and the first row is the title with username, Ip Address, machine name if scrow down to row 500, I lost the first row of the title bar along with the page, is anyway when I scrow down I can have my first row of title bar
|
| know the solution- find the operations? | 04 Oct 2007 20:15 GMT | 4 |
I have an old checkbook/billing issue. I'm trying to figure a combination of billing amounts that equal an amount that was paid. simple terms, lets say there were vaild bills outstanding in the amount of
|
| cross referencing | 04 Oct 2007 20:01 GMT | 1 |
I have a chart of accounts where an account no needs to match to a product no. ie 30101/100 is correct and 301010/050 is incorrect. When preparing journals to post into our accounts program, I use a spreadsheet. I need a way to validate the account nos and products
|
| simple automatic sorting | 04 Oct 2007 19:46 GMT | 11 |
Thanks for reading... I have a spreadsheet with a total of 7 columns, B through H. One of the columns, column F, contains dates. I want the spreadsheet to automatically sort itself by sorting column F, in an order which puts the oldest date
|
| Combo box | 04 Oct 2007 18:27 GMT | 5 |
I am using excel 2000. I am creating a simple data-input sheet, where the user will be entering name, addresses, etc etc. - with each field in its own column. I would like a column for "Job Title" where the user must choose from a pre-determined value - e.g. Receptionist, ...
|
| How is excel's stdev formula different from what I see in wikipedia ? | 04 Oct 2007 18:13 GMT | 6 |
1. In wikipedia, the standard deviation for a population of 5, 6, 8, 9 is shown to be 1.58, which seems correct to me. (http://en.wikipedia.org/wiki/Standard_deviation) 2. In excel, copy paste the following data on a new sheet, and you
|
| "Name Conflict" opening an Excel 2003 workbook | 04 Oct 2007 18:13 GMT | 7 |
I'm getting a "Name Conflict" "Name cannot be the same as a built-in name." Old name: Print_Area New name: All of the solutions I've read is to load this into Excel 2003, fix the
|
| Auditing formulas month over month | 04 Oct 2007 18:08 GMT | 4 |
I tried a few searched, but had no luck in finding a solution. We have a few very complex spreadsheets, and am looking to find a way to ensure completeness and accuracy of the spreadsheets month over month. Currently we do the following:
|
| hyperlink changes after save | 04 Oct 2007 13:37 GMT | 1 |
in office 2003 we have the problmem that when we make a hyperlink, to a share in our nw, it works fine, but when we save the sheet, it doesn't anymore. Can someone help us out?
|
| Excel file does not open | 04 Oct 2007 13:33 GMT | 3 |
My Excel file with the proper password does not open. If I type password, Excel opens with top bar: Microsoft Excel - [File name] . But it looks like standard Excel without file (blank), most funcutions in the Groups is hidden ( also Show)
|
| Formula shows up instead of result | 04 Oct 2007 13:13 GMT | 3 |
EXCEL 2007 From time to time when I do a VLOOKUP between two different workbooks the formula shows instead of the result. Sometimes if I delete the column and insert a new one and re-do it all is ok. But there are times when nothing
|
| Importing range of cell values from several workbooks to one | 04 Oct 2007 13:12 GMT | 2 |
Hello, I am new to Excel, so any help is very appreciated. I have one workbook with 4 sheets. What I need to do is to import values from several workbooks in that one. I need to select the source file and import fixed range of values from that
|
| excel file does not open when doubleclicked | 04 Oct 2007 12:36 GMT | 3 |
we have a user accesing office packages through terminal server. whenever he receive an excel attachment in outlook 2003 , he cannot open it by double clicking on it. no error message is displayed. the excel program opens with a black sheet in the background.
|
| New workbook/sheet defaults | 04 Oct 2007 11:35 GMT | 8 |
I'm using Excel 2003 and have put two files Book.xlt and Sheet.xlt in the startup folder whose path is specified in: Tools|Options|General|At startup open all files in: Sheet.xlt works fine for adding new sheets and Book.xlt works fine for new
|
| Error Validation Problem | 04 Oct 2007 11:03 GMT | 1 |
Can anyone help me. I have a spreadsheet I am using in Excel 2007 and despite having checked for errors and told it to ignore errors I still keep getting a wrning about 'one or more invalid references'. I have unchecked the box that checks for errors in the background - but still
|