You can trick Excel into allowing the circular reference by using the steps provided in this other Fixya post here:
http://www.fixya.com/support/t1207484-reopen_circular_reference_file_in_excel
SOURCE: Circular reference working how to open excel file
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 ?
A workbook
is a spreadsheet file. By default, each workbook in Excel contains three pages
or worksheet
The term spreadsheet is often used to refer to a workbook, when in
actual fact, spreadsheet refers to the computer program, such as Excel.
So,
strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.
204 views
Usually answered in minutes!
×