Home Topics excel How to solve excel circular reference

How to solve excel circular reference

Feb 14, 2020 am 09:39 AM
excel

How to solve excel circular reference

How to solve excel circular reference?

Method 1

You need to find the "excel option". This place is in the "Tools" option in the Office 2003 version, and in the Office 2007 version It’s hard to find, so I’d like to emphasize this to avoid some friends not being able to find it.

Secondly, click the "Formula" option. In the "Calculation Options", you can see that "Enable iterative calculation" is not checked. After checking it, you can solve the "circular reference" "Warning problem, indicating that Excel can perform circular references by default.

Finally, in "Formula Audit" on the "Formula" tab, click "Error Check" and you can see that "Circular Reference" has turned gray and is in an inoperable state.

Method 2: For formula usage errors

For "circular reference" warnings caused by formula usage errors, in this case, the formula itself needs to be changed. In the "Formulas" tab, you can see in the drop-down triangle of the error check that "Circular Reference" is editable.

In the right pull-down option of "Circular Reference", you can see the cells that use the wrong formula and modify or delete them. Only a group of cells with circular references will be displayed here at a time. You need to operate one by one to finally avoid the "circular reference" warning.

After deleting the formula, you can avoid repeated "circular reference" warnings.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to solve excel circular reference. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to filter more than 3 keywords at the same time in excel How to filter more than 3 keywords at the same time in excel Mar 21, 2024 pm 03:16 PM

How to filter more than 3 keywords at the same time in excel

What should I do if the frame line disappears when printing in Excel? What should I do if the frame line disappears when printing in Excel? Mar 21, 2024 am 09:50 AM

What should I do if the frame line disappears when printing in Excel?

How to type subscript in excel How to type subscript in excel Mar 20, 2024 am 11:31 AM

How to type subscript in excel

How to change excel table compatibility mode to normal mode How to change excel table compatibility mode to normal mode Mar 20, 2024 pm 08:01 PM

How to change excel table compatibility mode to normal mode

How to set superscript in excel How to set superscript in excel Mar 20, 2024 pm 04:30 PM

How to set superscript in excel

Where to set excel reading mode Where to set excel reading mode Mar 21, 2024 am 08:40 AM

Where to set excel reading mode

How to use the iif function in excel How to use the iif function in excel Mar 20, 2024 pm 06:10 PM

How to use the iif function in excel

How to read excel data in html How to read excel data in html Mar 27, 2024 pm 05:11 PM

How to read excel data in html

See all articles