Compatibility checker - modify default selection?

mjc543

New Member
Joined
Oct 25, 2015
Messages
6
Hi, I'm trying to figure out if there's a way to change the default for the Compatibility Checker "Select versions to show" drop-down list (i.e. 97-2003, 2007, 2010). When running a compatibility check in a large workbook with lots of pivot tables, the compatibility checker can take quite a long time to run (upwards of 2 minutes), so it would be helpful to eliminate all but 2010 from the options (I don't care if 2007 or 97-2003 aren't compatible). Anyone know a way to do this? Or am I stuck with all 3 being selected by default? My organization is about half 2013 and half 2010, so for the time being I need to maintain one-generation backwards compatibility. Thanks

-MIKE

Edit: the Compatibility Checker actually runs *before* you have the option to change "Select versions to show" which is kind of backwards to me, but you know, Microsoft.
 
Last edited:

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,099,568
Messages
5,469,457
Members
406,653
Latest member
CBeeker

This Week's Hot Topics

Top