Hi,
I'm trying to optimize the compatibility of my excel file with older versions of excel (2010 and above) that other users may be using. I have currently 3 significant losses of functionality that I dont know how to correct:
1. The first two refer to "One or more cells in this workbook contain a formula that has spilled or may spill in the future. These formulas will be converted into legacy array formulas and will not spill or change dimension in order versions of excel".
This alert refers to cells with the following formulas:
I don't really understand which part of the formula is related to the spilling? And what should I do to avoid any compatibility issue?
2. The third error refers to "One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These bars will not be supported in earlier versions of Excel". Here, i'm not sure to understand what it means exactly as the cells have formulas that return positive values. Is there an option to change / check somewhere?
3. After checking the compatibility of excel's formulas, formatting, etc, is there a way to also automatically identify if some vba code in my workbook is not compatible with earlier versions?
Appreciate any help on that
Thanks a lot!
Bookmarks