I have a sheet that persistently reports, "External reference is not valid" I can't find the invalid reference. How can I find it? Thanks for any...

was entering a all of sudden i couldnt type

Hello, I am using the following vlookup formula: =VLOOKUP(A2,SF_Input!A:I,10,FALSE) however i am receiving an error: #REF! I have also tried the following:...

I have a spreadsheet that has multiple worksheets. The first worksheet is a status tracking tool for the other worksheets which contain all the daily...

I have a form that has a drop down list of different equipment numbers. Is there a way I can print the form with it automatically putting in the next number...

If I have excel open twice on the same PC (different monitors) and I save each file, if I look at the MRU list in excel, it doesn't show them. This is excel...

I have an Excel '07 file that I created for shared use; however, the users all have '03. I'd like to keep it in '07 due to size. I had them download...

I am using a predesigned template from Microsoft for Loan Amortization. I want to enter a decimal number instead of a whole number in the cell for years. ...

I have 2 worksheets: "Main" & "Other". Both have 2 columns. "Main" & "Other" have identical Column A - Invoice number 10 positions (positions 5, 6 and 7 will...

I am referencing a column from a seperate sheet within one file. The problem I have is that when I insert a column my formulas are not updating properly on...

Hello Everyone, I am rather new to excel and find it is a very adaptive tool for use in many ways. I am trying to create a spread sheet that keeps track of...

I'm trying to calculate by quarter how much an employee will cost depending on when they are hired. I have a column for 4Q09 (Col R4), 1Q10 (Col S4), 2Q10...

I have a pivot table feed off a table 2 column talbe with booleans in teh second column. I want te count the TRUE occurences. However the Count property of...

I am trying to add the same words to the beginning of each cell in a column like for example the following ""abc.com/catalog/" to the beginning of the...

Hi I m using excel 2003 and I would like to know if it is possible to set several target cells to the solver. As we have several adjustable cells, is it...

Within Microsoft office 2003, there is a feature available that is: where I placed the mouse that cell, area or field would be highlighted. Does Microsoft...

When I open one particular workbook I get two copies labeled :1 and :2. Whwn I make changes to one, the second one is also updated. How do I delete one of...

Hi, my question is this: I recorded a few macros for clearing the contents in ranges of cells. I gave the ranges names, ie. "cellstoclearplow" These macros...

I am trying to re-create something I have seen in an excel worksheet. The auther had a line beneath the header and to the right of one column. This "line"...

I export time statistics into Excel 2007 so that I can get totals for multiple entries. The time format is hh:mm:ss and in the hours field it adds a leading...