Forum Discussion
Excel Compatibility Mode-Turning off by default
Thank you, however my question was not about #REF error. My question: Is compatibility mode in excel can be turned off by default NikolinoDE ?
Please inform about, Excel version, operating system, storage medium (hard drive, One-Drive, Sharepoint, etc.).Welcome to your Excel discussion space!
Maybe this guide will help you in advance :).
If not, as mentioned above, please provide more information.
1.Click on "File".
2.Then on "Options"
3.Under the menu item "Save" should be the basic setting of the format
for Excel "Excel Workbook (*.xlsx)" and
for PowerPoint must be set to "PowerPoint Presentation".
If not, use the drop-down box to search for and select the correct format.
Then scroll down and confirm with OK
4.Confirm the message with "Yes".
**If your document or template is saved in the wrong/old format, you must
save the document again. It is best to use "Save as" and then the
select the desired file type.
Thank you for your understanding and patience