Optimize Workbook Functions
Optimizing Workbooks for the Selective Column EnhancementNote -This feature was introduced in version 2.01.0034.
|2.01.0022 and earlier||These versions can not be automatically optimized because they lack square brackets around field names. If the workbook uses only queries (i.e. the workbook does not contain any Office Connector functions) then you can disregard the optimization message. Simply re-save the workbook and the prompts will no longer be displayed. You can suppress all further notices by unchecking Prompt when opening un-optimized workbooks under Advanced preferences.|
|2.01.0023 to 2.01.0033||These versions can be automatically optimized. Save the workbook after optimization is complete to save the changes and prevent future messages.|
|2.01.0034 and above||These versions are already optimized.|
Square Brackets in Filters
|Note -||Partially fixing a filter by putting square brackets around some field names but not others will cause errors to be returned to the spreadsheet until all column enclosers are consistent. This will be a normal experience while optimizing older workbooks.|