Skip to Main Content
Categories Syndication
Created by Vincent Meskers
Created on Apr 2, 2023

Syndicate - Excel add Office 365 formulas/functionality

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.

  • Attach files
  • Guest
    Reply
    |
    Apr 16, 2025

    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.

  • +4