Pat McMillan 8/5/2008, 9:37 น. Thank you for your report. We are working on a fix for the circular reference problem and hope to have an update with the fix out soon. It would still be very valuable to have your file to use as part of our verification of the fix. A file for the other problems you mention would also be very, very helpful.

What’s this about Circular Formulas? You may have come across them before but if not here’s a quick rundown. A circular formula is one that refers back to itself either directly or indirectly. Let’s take a look at an example. Let’s look at a direct example.

For example I am keeping track of time that I have worked on a project so when I put an X in a cell that says I worked on it on Monday at this time. Total converter for mac. Each time I open the document the time is changing on me. Any way to make it so it doesn’t change the time? Thank you and God Bless, Andrew E • Barbara says. I used your formula and it worked perfectly. But I have a very small problem.

Learn the basics of Excel circular reference - how to check workbooks for circular formulas, and how to enable, find and remove circular references in Excel. And how to enable, find and remove circular references in Excel. Circular reference in Excel - how to check, find, enable, or remove. So you need to turn it off before you. I have a large spreadsheet with a lot of built-in circular references. I have built in VBA code to set to manual and iterative calculation on opening and also code to force a calculation on workbook open after I set to iterative calculation. Further, Excel sometimes puts itself in a state where it can’t resolve the circular reference. The solution is to temporarily disable the formulas and then enable them again once the formulas work. However, tracking down all of the tendrils of a circular reference was always tricky for me until I discovered a hidden feature in Excel. I am not a big fan of using excel for doing complicated engineering calculations. I have spent way too much of my life trying to find the mistake another's convoluted spreadsheet, it is all to easy to make 'spaghetti code' in a spreadsheet.

However, if manual recalculation is selected, you must click the Calculate Now (F9) command button on the Formulas tab of the Ribbon or press F9 or Ctrl+= as well.

The figure illustrates the classic example of a circular reference, which ultimately can be resolved. Here, you have an income statement that includes bonuses equal to 20 percent of the net earnings entered as an expense in cell B15 with the formula =–B21*20% This formula contains a circular reference because it refers to the value in B21, which itself indirectly depends on the amount of bonuses (the bonuses being accounted for as an expense in the very worksheet formulas that determine the amount of net earnings in cell B21). To resolve the circular reference in cell B15 and calculate the bonuses based on net earnings in B21, you simply need to select the Enable Iterative Calculation check box in the Calculation Options section of the Formulas tab in the Excel Options dialog box (File→Options→Formulas or Alt+FTF).

I saved the workbook, and reopened it. All seems fine. Also opened it in Excel 2003 on PC, and it worked fine. Hope that helps in some way. Hope you MS figures it out and releases a patch soon!

Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. When I click anywhere (trying to select a cell, or an excel menu item.clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated.