Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value Problem - Inconsistent Formulas After Column Insertions
Using Excel 2007. Workbook was originally 2003.
I cannot find a way around the "inconsistent formula" problem that causes the total column at the end of the worksheet to return the #VALUE error. There are 6 columns in the worksheet that use IF, AND and VLOOKUP formulas. The cells with the formulas have one columen with another formula in it. The first 4 columns with the formula that I am using do not have the "inconsistent formula" problem. The last 4 of the group does. The only difference between any of the columns is the column number for the data to be pulled from. i.e., the same formula referencing to the same worksheet. The only thing that I popping out to me at the moment is that I inserted these 4 columns in the worksheet. As stated it is a 2003 worksheet and am using 2007. The active content being disabled and/or enabled doesnt make a difference. I have addtiionally killed all the links to other workbooks. Any assistance would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value Problem - Inconsistent Formulas After Column Insertions
See your other post
-- Biff Microsoft Excel MVP "dpridemore" wrote in message ... Using Excel 2007. Workbook was originally 2003. I cannot find a way around the "inconsistent formula" problem that causes the total column at the end of the worksheet to return the #VALUE error. There are 6 columns in the worksheet that use IF, AND and VLOOKUP formulas. The cells with the formulas have one columen with another formula in it. The first 4 columns with the formula that I am using do not have the "inconsistent formula" problem. The last 4 of the group does. The only difference between any of the columns is the column number for the data to be pulled from. i.e., the same formula referencing to the same worksheet. The only thing that I popping out to me at the moment is that I inserted these 4 columns in the worksheet. As stated it is a 2003 worksheet and am using 2007. The active content being disabled and/or enabled doesnt make a difference. I have addtiionally killed all the links to other workbooks. Any assistance would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Formula? | Excel Discussion (Misc queries) | |||
Name ranges and insertions to spreadsheet to update charts | Charts and Charting in Excel | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
Excel insertions (drawings, word art, pics, etc) are not visible. | Excel Discussion (Misc queries) | |||
3-d referencing inconsistent | Excel Discussion (Misc queries) |