Cell in a excel workbook is not updated if the referenced cell is in another crypt excel workbook. Ie: when a cell in a crypt excel sheet is modified, all references to that cell in other workbooks do not reflect the modified cell.
This issue occurs regardless if the crypt workbook is open or not.
If your spreadsheet relies upon data from another source which is encrypted then Excel has no access to it. You’ll need to manually decrypt all the other spreadsheets which are linked to your main spreadsheet.