I have an Excel file that I am trying to send to a friend who has a mac. When he opens it, it gives him REF! errors. It has multiple tabs with cells that reference other tabs in that spreadsheet. My file has no errors, but his does. I wasn't sure if it was something related to a PC reading from a mac or the tab issue.

One of the errors he gets is: "We found a problem with some content in (file name). Do you want us to try to recover as much as we can? If you trust the sourse of the is workbook, click yes."
Then says "Excel was unable to open the file repairing or removing the unreadable content."
Then "The XML file repair result to (file name).xml cannot be opened because there is no available data view (XSLT)."

When I open the file I do get a Security Alert - Data Connection. Data connections have been blocked... Then it lists the file path of the file that is open.

Any ideas how to fix this?