Forum Discussion
Solved
circular reference warning stops me opening the file in excel
I am using Office 2013 also Office 365 on other laptop. I have a worksheet I have been using for almost 2 years without a problem and have been updating every single day, However I can no longer acces...
- Lastly i could open it ... i opened a new excel file.. go to file/options/formulas/circulation options/ select to manual, then press ok, then go to file again select open select the target file then at the option of (open) near the file name select open and repair, should bring up repair and extract data option select extract data then select recover formulas select ok again and it openes perfectly ... thank you for all the help and your time everyone
some follow up questions.
what happens if you open another file? will it open correctly? is it just this file that causing the issue?
Do you have any workbook in your Excel start up folder?
could you post a screenshot of the grayed out excel?
Lastly i could open it ... i opened a new excel file.. go to file/options/formulas/circulation options/ select to manual, then press ok, then go to file again select open select the target file then at the option of (open) near the file name select open and repair, should bring up repair and extract data option select extract data then select recover formulas select ok again and it openes perfectly ... thank you for all the help and your time everyone