document does not open

%3CLINGO-SUB%20id%3D%22lingo-sub-2110285%22%20slang%3D%22en-US%22%3Edocument%20does%20not%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2110285%22%20slang%3D%22en-US%22%3E%3CP%3Ethe%20document%20does%20not%20open.%3CBR%20%2F%3EExcel%20writes%3A%20cyclic%20links%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2110340%22%20slang%3D%22en-US%22%3ERe%3A%20document%20does%20not%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2110340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F950973%22%20target%3D%22_blank%22%3E%40amurresurs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2110315%22%20slang%3D%22en-US%22%3ERe%3A%20document%20does%20not%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2110315%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F950973%22%20target%3D%22_blank%22%3E%40amurresurs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20workbook%20is%20hidden.%3C%2FP%3E%0A%3CP%3EAfter%20clicking%20OK%20in%20the%20circular%20references%20warning%2C%20click%20Unhide%20in%20the%20Window%20group%20of%20the%20View%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3ESelect%20your%20workbook%2C%20then%20click%20OK.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20circular%20reference%20are%20in%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ECell%20B29%20of%20the%20%D1%81%D1%82%D0%B0%D0%B4%D0%B8%D0%B8%20sheet%3A%20%3DSUM(B29%3AB35)%20refers%20to%20B29%20itself.%20Change%20it%20to%20%3DSUM(B30%3AB35)%3C%2FLI%3E%0A%3CLI%3ECell%20B23%3A%20%3DSUM(B23%3AB28).%20Change%20this%20to%20%3DSUM(B24%3AB28)%3C%2FLI%3E%0A%3CLI%3ECell%20B11%3A%20%3DSUM(B11%3AB17)%20becomes%20%3DSUM(B12%3AB17)%3C%2FLI%3E%0A%3CLI%3ECell%20B5%3A%20%3DSUM(B5%3AB10)%20becomes%20%3DSUM(B6%3AB10)%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

the document does not open.
Excel writes: cyclic links

2 Replies

@amurresurs 

The workbook is hidden.

After clicking OK in the circular references warning, click Unhide in the Window group of the View tab of the ribbon.

Select your workbook, then click OK.

 

The circular reference are in:

  • Cell B29 of the стадии sheet: =SUM(B29:B35) refers to B29 itself. Change it to =SUM(B30:B35)
  • Cell B23: =SUM(B23:B28). Change this to =SUM(B24:B28)
  • Cell B11: =SUM(B11:B17) becomes =SUM(B12:B17)
  • Cell B5: =SUM(B5:B10) becomes =SUM(B6:B10)