corrupt excel preferences in office 365 for mac

When the second user (Office 365) tries to open the already opened file (Office 2011) it gives the following error: If I want to repair the seemingly corrupted file, a second error pops up.

Excel versions are: Office 365 Ver: 16.17, Office 2016 Ver: 16.16.2.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged macos microsoft-excel afp or ask your own question.

On the Mac version, you can only open a read-only copy of embedded files.

Office exists on other platforms too, like the Macbut those versions are missing some products and features.

Check out that link for a detailed list of updates, but the big stuff includes bringing some long overdue features to the macOS version, like collaborative real-time editing, automatic saving of documents stored in the cloud, and Google Calendar and Contacts support in Outlook (finally).

That said, there are still features (and entire apps) that you might miss out on if youre working with the Mac version.

Almost all editions come with Word, Excel, PowerPoint, and OneNote.

Depending on the edition you buy, you might also get apps like Outlook, Publisher, and Access.

While you can easily find comparable apps for macOS, its unlikely youll be able to bring your Publisher files from the Windows version across very wellat least not without having to work them back into shape.

You cant get Access on the Mac, so if you (or your company) works with Access databases, youre out of luck.

It lets project managers develop project schedules, create and assign tasks and resources, and manage it all with real-time input from peoples calendars.

While macro support is included in Office on macOS, that support is not quite as fully featured as it is in the Windows version.

If you make extensive use of macros, or use complicated macros, you should expect that some wont work.

If youre using a Mac and connecting to your companys SharePoint servers, you might find that some aspects of SharePoint are not as well-supported as they are in the Windows version of Office.

For example, roaming (the ability to use Office on different computers and have your configuration follow you) is not available for macOS.

However, if your system is part of a company network, these things have likely been thought out in advance.

This makes it harder to recover files that Word might not recognize as Word documents.

That way, when someone else opens the file, it displays correctly even if they havent installed the fonts you used.

The January 2018 update to Office 2016 for macOS does bring the Mac versions support of PivotCharts more in line with the Windows versions, but you may still find some charting abilities missing.

That said, there is one feature worth noting thats missing on the macOS side of things: video and animation triggers.

These triggers let you make an animation effect begin playing when you click the object being animated, or automatically at the beginning of an audio or video clip.

It just doesnt include the advanced triggers that the Windows version does.

And, as we mentioned before, the newest update to Office 2016 for macOS now brings support for Google Calendar and Contactsa pretty big missing feature for lots of people.

For example, in the Windows version, you could embed an Excel file.

Clicking on that Excel file in OneNote opens a full, editable version of the file in Excel.

Corrupt Excel Preferences In Office 365 For Mac