I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters holidays in one sheet and those days are automatically highlighted (as well as weekends) in other sheets. Here are links to. Feel free to open them to get an idea of what I'm talking about. Now the point is that according to my targeted user the conditional formatting is lost in Excel 2003. I fired up the compatibility report and it does say that there are issues. Workbook contains conditional formatting that cannot be displayed: Earlier versions of Excel cannot display data bars, color scales, and icon sets.

But there are no data bars, color scales or icon sets. I use a formula to set the font style and that's it. That's also what Excel 2003 should be capable of. The functions used in the formula are also available in Excel 2003: INDIRECT, MOD, DATE, MONTH, IF, AND, OR, MID, CHOOSE, WEEKDAY, COUNTIF.

If I were to guess, I'd say that Excel 2011 inserts one of those things (data bars, color scales, icon sets) automatically. But then again, there are no other rules than my own. And there are only 3 of them, so that shouldn't be a problem either.

Note: The Compatibility Report checks for compatibility issues with Office 98 for Mac through Microsoft Office for Mac 2011 and with Windows versions from Office 97 through the Microsoft Office 2010. How to troubleshoot crashing and not responding issues with Excel. Microsoft Office Excel 2007 Excel 2010 Excel 2013 Excel 2016 More. Select Product Version. Perform a selective startup to determine whether a program, process, or service conflicts with Excel. When you start Windows as usual, several applications and services. Check a document for compatibility. The Compatibility Report checks for compatibility issues with Office 98 for Mac through Microsoft Office for Mac 2011 and with Windows versions from Office 97 through the Microsoft Office 2010. If there are compatibility issues, the Compatibility.

Question: Q: Compatibility between MAC excel and windows excel More Less Apple Footer This site contains user submitted content, comments and opinions and is for informational purposes only.

Do you have an idea what could be wrong? Could you please help me spotting the error? Thanks in advance!

Troubleshooting Excel 2011 for the Mac Note: Between the steps below you can check if your problem is fixed in Excel 2011. Step 1: Shut Down and Restart your Mac Step 2: But sure that you have installed the latest updates for your Mac and Office 2011. Step 3: Installed add-ins can also give problems so go to Tools>Add-ins and uncheck them all in the add-in list and Close/Reopen Excel. If you not have problems now put them back one at the time (Close/Reopen Excel each time before you test) untill you find the one that give you problems. Step 4: Click on the Spotlight icon in the top right corner of your Mac and enter 'Disk Utility'to find and open open this program. Select your harddrive and click on 'Repair Disk Permissions' and when it is ready click on 'Verify Disk Permissions'.

Step 5: Problems with Preference and Toolbar files in Office 2011. But where are those files on your Mac? In the newest OSX versions the folders with the files are hidden 1: Close all Office programs first 2: Open a Finder window 3: Hold down the Alt key when you press on Go in the menu and click on Library Preferences folder In the com.microsoft.Excel.plist file Excel saves the changes you make to your preferences.

If you have never made a change to your preferences, it is possible you will not have this file. Application Support:Microsoft:Office:Preferences:Office 2011 folder If you have ever made changes to your menu or toolbars you will find a file here named Microsoft Excel Toolbars 4: The best way to discover whether the files above are giving you problems on your Mac is to drag the ones you find to your Desktop, and then re-start Excel. If the problems are fixed you should delete the files from your desktop. Excel will create new ones for you as soon as you change things in preferences or in your menus/toolbars. Step 6: Fonts can give many problems on a Mac, check out the webpages below for more information.

Step 7: Create a new user account, see if Excel work correct in this new user account. Step 8: If nothing is working I suggest: Complete removal followed by a fresh install. Best router for apple mac 2018. Follow the steps in this article: Start with step 1 and 3 and then reboot your Mac.

If it is not working after the reboot do step1, 3 and 7 and reboot (you have to repeat step 3 each time). See also the information on this page: Excel 2016 information Uninstall Office 2016 for Mac: In this article you can also find where Office 2016 store his preference files.