Add a new idea Subscribe
Status Likely to implement
Categories Syndication
Created by Vincent Meskers
Created on Apr 2, 2023

RELATED IDEAS

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
  • Admin
    Iamail Lemkaddem
    Jun 16, 2025

    Hi @Guest , Thanks for resurfacing this

    We’re picking it up now as part of a bigger improvement to the Advanced Excel Extension. The use case you described having different tabs for filtered subsets like specific product types is exactly what we want to support moving forward.

    It’s on our radar now, and we’ll keep you posted as we get into the next steps. Really appreciate you flagging this early your input’s been a big part of pushing this forward.

    Kindly/ Sr PM Iamail Lemkaddem

    Reply
  • Guest
    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.

    Reply
  • +4