ExcelReportLink v2017.2.1.195

ExcelReportLink v2017.2.1.195 was released on 28/02/2017.

Enhancements

MYOB AccountRight Live

Enhanced data files dialogue for MYOB AccountRight Live to only show SERVER field if using SERVER data file.
Fixed issue with CategoryName not coming through to Sales Pivot for MYOB Live.
Fixed issue with CategoryNumber being truncated to 10 characters instead of 15 for MYOB Live.

MYOB Exo

Updated MYOB Exo interface to work.
Updated MYOB Exo interface to use sub accounts for accounts, jobs or categories.
Updated MYOB Exo interface to use brances for jobs or categories.

Xero

Added option for XERO Data File to nominate which tracking category to use for Jobs and which to use for Categories.

'Get Data

Enhanced get data to not install data warehouse when using developer mode.
Enhanced get data log to expicit state if it succeeded or failed.
Enhanced get data to have option to let users keep using excel while get data is running.
Enhanced get data to not force to full get data if nothing changed after clicking manage data files.
Enhanced get data progress to ensure the get data progress dialogue is always displayed in the task bar.

Miscellaneous

Added new Custom Data Files type.
Restructured Data File Interface folders.
Enhanced toolbar to be more consistent and not flicker.
Updated Settings workbook, menu and help to separate Options And Administration into 2 sheets: Options and Backup.
Enhanced ShowAll and HideAll buttons to prompt to enable/disable developer mode.
Enhanced code to add DefLookup named ranges when developer mode is switched on.
Year and MonthCalendarDisplay are now only licensed on the Advanced fields and not Basic fields.
Enhanced startup to ensure menu is refreshed immediately upon loading and also after the get data.
Fixed issue with dropbox and conflict databases to ensure they do not get added to the list of data warehouses.