Question about Microsoft Excel for PC

2 Answers

Circular reference working how to open excel file

Circular Reference Warning
One or more formulas contain a circular reference and may not calculate correctly. Circular reference are any refereces within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that referes to another cell which depends on the original cell's value both contain circular references.
For more information about understznding, finding and removing circular references, click ok. if you want to create a circular reference, click cancel to continue.

Posted by on

  • 2 more comments 
  • amal_kodeh Dec 22, 2008

    Circular Reference and may not calculate correctly. Circular references are any references within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular references, click OK. If you want to create a circular reference, click Cancel to continue.

  • Anonymous Feb 27, 2009

    Circular Reference Warning
    One or more formulas contain a circular
    reference and may not calculate correctly. Circular reference are any
    refereces within a formula that depend upon the results of that same
    formula. For example, a cell that refers to its own value or a cell
    that referes to another cell which depends on the original cell's value
    both contain circular references.
    For more information about
    understznding, finding and removing circular references, click ok. if
    you want to create a circular reference, click cancel to continue.

  • JULIAN May 11, 2010

    Which version of Excel are you using?

  • Peter Sturniolo
    Peter Sturniolo May 11, 2010

    Which cell (A5, B7, etc), and what is the exact formula in the cell?

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I have a value in cell E1 say 2500000. I now enter the formula =E1/1000000 the result is a circular reference. How to remove it ?

Posted on Apr 06, 2010

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

Clicking cancel will invalidate the formulae, circular references refer to the dependant and precedent cells using each other.

Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.

Posted on May 22, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Microsoft Project 2007 Corrupting Data


Other solutions are to recover from backup. Open on another machine with Project or repair the User Profile. It may be corrupt. If you can log in with another username to the PC and try to open the file.

OR:

1] Go t File --> Options --> Trust Center --> click on Trust Center Settings --> Select the option "Allow loading files with legacy or non-default file formats" and try opening the file.

2] Open a blank project and try inserting the problematic file and try opening it.

Another method might be applied in case severe .mpp corruption http://www.mpp.openfiletool.com/ MPP Open File Tool

Jul 26, 2015 | Microsoft PROJECT Business & Productivity...

1 Answer

Excel Spreadsheet question


cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Apr 09, 2014 | Microsoft Excel for PC

1 Answer

Unable to open EXCELL 2007 workbook containing a circular reference problem.


open Excel
Click the 'Microsoft Office' button and click 'Excel Options'. Click the 'Formulas' button. From 'Calculation options' section, un-select the 'Automatically' option. then use file->open->yourfile.xlsx. It should now open. Find the circular reference and fix it. Then save the file.

Mar 18, 2013 | Microsoft Office Excel 2007 Full Version...

1 Answer

My Excel 2007 status bar shows the words "Calculate" even though my calculation is set to automatic. From my experience with the prior version of Excel, this indicates a circular reference error....


A couple of possible causes:

Setting Workbook.ForceFullCalculation to True will cause this.

The Iteration Option is turned on and the workbook contains circular references. Turn off Iteration (Tools-->Options-->Calculation) and press F9-- it may show "Circular Reference."

Jun 20, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

MS Excel-Values in the formula in place of cell reference


Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

1 Answer

AutoCAD LT 2008 (xref circular references)


The "circular reference" indicates that the xref you are pulling in is also xrefing the drawing file you are in which creates this circular reference to each other. The error message is only a warning and does not prevent you from working and saving changes. To get rid of the error message, close the primary drawing file and then open the reference drawing and DETACH the xref that is linked to your primary drawing. Save the changes and then open the primary drawing file again to see if the error was resolved.

Mar 16, 2009 | Autodesk AUTOCAD LT 2008 SLM 10 SEATS...

2 Answers

Can't reopen circular reference file in excel


  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Nov 05, 2008 | Microsoft Excel for PC

2 Answers

Circular reference errer in excal file in office 2007 Problem. when i open excal seet and whant to change and save. then pc show problem? ple help me shamsherpatel


Hi shamsherpate

In order to remove this error message you need to locate and remove the incorrect references:

On the Formulas tab, in the Formula Auditing group, click the arrow on the Error Checking in-group button, point to Circular References, and then click the first cell listed in the submenu.

Tip You can move between cells in a circular reference by double-clicking the tracer arrows.
Review the formula in the cell. If you cannot determine whether the cell is the cause of the circular reference, click the next cell in the Circular References submenu.

Note The status bar displays the word "Circular References" followed by a reference to one of the cells contained in the circular reference.
Continue to review and correct the circular reference until the status bar no longer displays the word "Circular References."

Regards,
TheAssembler

Jun 06, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

1,300 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...