I assume many companies (like ours) are already using Office365. I found that with Syndication, templates containing formulas from Office 365 (e.g. filter, unique, textsplit) are not working and are converted to an array formula after downloading from iPMC.
Please add the most recent functionalities to iPMC too.
For anybody with similar problem, as workaround, I now add the formulas via VBA marco upon opening the workbook.
Please add this feature! It is greatly needed when for multiple clients. I need it when a tab is subset of the Work Area. For example, Tab1: All Data in work area. Tab2: Only product type 1, Tab3: Only product type 2, etc. We have to do complex VBA or index and match formulas since we cannt do Filter, unique, text split.