Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

078113 - 2007: Floating-point arithmetic may give inaccurate results in Excel

277605 - 2007: Incorrect Value Is Calculated When the Thousand Separator Is the Same As the Decimal Separator

214096 - 2007: Method to Calculate Interpolation Step Value

242237 - 2007: Worksheet May Not Recalculate Completely When You Repeatedly Press F9

Knowledge Base Articles - 2003

100825 - 2003: #VALUE error when you add text and values in Excel

Knowledge Base Articles - 2002

095811 - 2002: Error Message: 'Input Cell Reference Is Not Valid'

331505 - 2002: Excel May Stop Responding When You Try to Edit a Long Formula That Contains a Link

212064 - 2002: F4 Key Does Not Change Cell Formula Reference As Expected

214133 - 2002: Formula for Distance/Velocity Returned in Hours Minutes and Seconds

289841 - 2002: Formulas Return #VALUE! or #NAME! After Upgrade

214078 - 2002: How to Find the Percentage of Change Between Values

087299 - 2002: How to Suppress Error Values on a Worksheet

291050 - 2002: How to use the IF worksheet function to suppress the #DIV/0! error value in Excel

282163 - 2002: Ignored Error Flag Reappears When Worksheet Is Copied

277614 - 2002: Inconsistent Error Flags for Formulas in Worksheet Cells

292475 - 2002: Inconsistent Formulas Are Not Flagged as Expected

095479 - 2002: Method to Calculate Interpolation Step Value

Knowledge Base Articles - 2000

206358 - 2000: #NAME? Appears Copying Formulas to New Workbook

215703 - 2000: Calc Events Are Recalculated When You Open a Worksheet

109211 - 2000: Calculating Weighted Averages

216578 - 2000: Calculation Differences Between the Office Spreadsheet and Excel

248179 - 2000: Calculation Problems When Custom Function Creates a Defined Name

212013 - 2000: Calculation of Formula in Formula Bar Returns #VALUE!

213970 - 2000: Cell Linked to Text-Formatted Cell Shows Formula Not Value

213909 - 2000: Cell References in Copied Formula Are Incorrect

214280 - 2000: Cell That Contains Formula Assumes Formatting of First Cell in Reference Range

212162 - 2000: Clicking Row or Column Divider Causes Recalculation

211894 - 2000: Comparison Value Changed from Fraction to Serial Number

209338 - 2000: Copied Formula is Pasted as a Value

210725 - 2000: Copying and Pasting Noncontiguous Range Loses Formulas

266443 - 2000: DDE Formulas Produce #NAME? Error in Shared Workbooks

213889 - 2000: Description of formulas to count the occurrences of text characters and words in Excel

214154 - 2000: Error Message with Formula Containing More Than Seven Embedded IF Statements

213900 - 2000: Error Message: Your Formula Contains an Invalid External Reference to a Worksheet

213558 - 2000: Error When Function Contains a Breakpoint

214360 - 2000: Error or Page Fault Linking to Workbook or Creating Formula

214243 - 2000: External Link Is Not Updated When Source Cell Is Moved

211507 - 2000: File Name in Formula Doesnt Appear Correctly

214374 - 2000: Formula References Are Incorrect After You Press CTRL+ENTER

214279 - 2000: Formula Returns Unexpected Positive Value

214241 - 2000: Formula for Cumulative Category Total

214079 - 2000: Formula to Count the Number of Rows in Which an Item Appears

248174 - 2000: Formulas Calculate Incorrectly After Changing Worksheet Name

257451 - 2000: Formulas Not Adjusted Automatically When You Enter New Data

214244 - 2000: How to Create a Formula to Correctly Evaluate Blank Cells

213490 - 2000: How to Manually Recalculate a Single Cell or Range

075513 - 2000: How to Reverse the Order of Words in a Text String

213633 - 2000: How to Show Quotation Marks in Function Results and Macros

214049 - 2000: How to calculate weighted averages in Excel 2000

215217 - 2000: Incorrect 3-D Formula Reference After Undo or Redo Paste

214373 - 2000: Incorrect Result Raising 10 to Very Large/Very Small Power

182191 - 2000: Link Formula Returns #REF! Error Value

214023 - 2000: Linked Cells Display #REF! Error Message with Dependent Workbook

211878 - 2000: Linked Formula May Return a Maximum of 255 Characters

214305 - 2000: Linked References Not Updated in Closed Worksheet

248216 - 2000: Links to Closed Workbook Are Not Updated Properly

217656 - 2000: Links to Excel 4.0 Macro Sheets Do Not Update

212199 - 2000: List of Errors That Formula AutoCorrect Detects

214316 - 2000: Order of Operations Performed in Formulas

214043 - 2000: Paste Function Does Not Enter Formulas As Arrays

211999 - 2000: Unable to Use File URL in Linking Formulas

214003 - 2000: Updating Incorrect Calculations on Pentium-Created Worksheet

214344 - 2000: Using Iterations and Maximum Change in Calculations

209284 - 2000: Values Pasted from Clipboard in Place of Formulas

213465 - 2000: Visual Basic Macro to Change Between Relative and Absolute References

213440 - 2000: Visual Basic Macros That Add or Remove Hidden Apostrophes

Knowledge Base Articles - 1997

174290 - 1997: #NAME? Error in Formula After Copying into Data Range

174288 - 1997: #NULL! Error Copying Formula That Contains a Label

167079 - 1997: 'Not Enough Memory' Error Using Linking Formulas

173272 - 1997: Calculating Worksheet Causes Crash After Running Module

172066 - 1997: Calculation Stops at Zero Percent or Occurs Very Slowly

157031 - 1997: Calculation of Formula in Formula Bar Returns #VALUE!

093681 - 1997: Cells Made Blank with Quotation Marks Act As Text Cells

167672 - 1997: Clicking Row or Column Divider Causes Recalculation

048606 - 1997: Comparison of Values Does Not Return Correct Result

231635 - 1997: Copying and Pasting Noncontiguous Range Loses Formulas

178528 - 1997: Double-clicking Link Formula Doesnt Open Workbook

167078 - 1997: Embedded Links to Other Workbooks Cause Error When Exiting

171314 - 1997: ErrMsg to Fix Formula When Comma Is Decimal Separator

171019 - 1997: Error Creating Circular References Between Instances

172753 - 1997: Error Updating or Modifying Link to DDE Server Program

176156 - 1997: Error or Page Fault Linking to Workbook or Creating Formula

158097 - 1997: File Name in Formula Doesnt Appear Correctly

101167 - 1997: Finding the nth Value That Meets a Condition

185749 - 1997: Formula AutoCorrect Inserts Formula with Incorrect R1C1 Cell Reference

184260 - 1997: Formula Is Not Recalculated After Paste Special Operation

172791 - 1997: Formula References Incorrect After Pressing CTRL+ENTER

174287 - 1997: Formula Returns Incorrect Value When Changed by a Macro

132686 - 1997: Formula Returns Unexpected Positive Value

108107 - 1997: Formula to Sum Digits of a Number

193158 - 1997: Formulas Not Displayed Properly with Data Table in Sheet

192810 - 1997: Formulas Not Recalculated After Moving Worksheet

118936 - 1997: Formulas in Imported Works File Not Calculated Correctly

186395 - 1997: Formulas with Range-Style Cell Reference Are Not Updated

108280 - 1997: Function to compute average without high and low values

154134 - 1997: Functions in Filled Formulas May Not Be Recalculated

169970 - 1997: Hang While Editing Formula Directly in a Cell

028572 - 1997: How to Calculate the nth Root of a Number

154874 - 1997: How to Create a Conditional Format to Hide Errors

142526 - 1997: How to Determine Top/Bottom Used Cells in a Sparse Array

051918 - 1997: How to Force MS Excel to Always Reference the Same Cell

174868 - 1997: How to Obtain the Excel 97 Auto Recalculation Patch

136738 - 1997: How to Sum Either Odd or Even Rows Only

171640 - 1997: Illegal Operation Occurs While Recalculating Workbook

182873 - 1997: Link in Merged Cell Is Not Recalculated on Copied Sheet

172065 - 1997: Link to File on Network Is Not Updated Correctly

117721 - 1997: Linked Cells Display #REF! Error with Dependent Workbook

166691 - 1997: Linked Formula May Return a Maximum of 255 Characters

165568 - 1997: Links In Microsoft Excel 4.0 Workbooks Are Incorrect

217129 - 1997: Links to Excel 4.0 Macro Sheets Do Not Update

161747 - 1997: List of Errors That Formula AutoCorrect Detects

171239 - 1997: MS Excel Does Not Resume Calculation After Halting

031951 - 1997: Mathematically Applying One Number to a Group of Cells

136761 - 1997: Memory Errors Appear When You Calculate a Custom Function in a Cell

156603 - 1997: Microsoft Excel Inserts a Defined Name in Formula

252197 - 1997: Navigation of Links Between Workbooks Does Not Work After Save and Reopen

235397 - 1997: Negative Number Multiplied with Null or Zero Produces a Negative Zero on the Alpha Platform

072622 - 1997: Optimizing Worksheets for Fastest Calculation

169971 - 1997: Page Fault Editing Formula That Returns #NULL! Error

167188 - 1997: Page Fault Using Formula Containing Boolean Functions

072573 - 1997: Parsing Names in a Worksheet Without Data Parse in Excel

156888 - 1997: Paste Function Buttons Missing in Formula Palette

175050 - 1997: Recalculating Displays Values from Another Workbook

186452 - 1997: Some Formulas Are Not Refreshed with Data Table in Workbook

171339 - 1997: Some Values Not Recalculated When Using Multiple Formulas

157417 - 1997: Unable to Use File URL in Linking Formulas

124310 - 1997: Updating Incorrect Calculations on Worksheet Created on Pentium

177856 - 1997: Using Iterations and Maximum Change in Calculations

121820 - 1997: Visual Basic Function to Calculate Cross Product

171726 - 1997: Worksheet Displays Incorrect Values After Calculation

191661 - 1997: Worksheet Not Recalculated with More Than 240 Formulas in Same Row