Can't save Workbook with macros after changes

Hello!

I've received an Excel file that, apparently, has macros.

Please, help me with two issues:

1) I've done some changes to the data and I need to save the file, but Excel wouldn't do it by answering me "Document not saved".
I've tried to save it as "Excel Marco-Enabled Workbook.xlsm", as "Excel 97-2004 Workbook.xls" and as "Excel workbook.xlsx", nothing works - it doesn't want to save the doc.
When I tried to save as the last option (see picture attached), it returned a file in which a lot of information is lost (see second picture attached)

2) Doing some formulas and computing certain things I need to create reference from other Sheets in this Workbook - it wouldn't create them, it wants me to pick up some other file in my documents to refer to but not to the neighboring sheet in the same document.

I would be sooo grateful for the help!
I truly need it and hope you will be able to help me - it is a serious thing, unfortunately.

Thank you!