Is there a fix as Upgrade to Office365 (Excel) formula automaticaly updated with @ operator?

Roy Sharma 1 Reputation point
2021-11-16T15:09:33.23+00:00

Updated 365 Excel users encounter formula change to function. We OneStream add-in through excel and there is now an issue with the @ operator.
149862-image.png

Is there a way for this to not update as it impacts many users in our Company?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
1,984 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,349 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Viki Ji_MSFT 4,241 Reputation points
    2021-11-17T08:21:33.657+00:00

    Hi @Roy Sharma ,
    Welcome to Q&A forum!

    According to my research and testing, I found that functions that return multi-cell ranges or arrays will be prefixed with @ if Array formulas were authored in an older version of Excel.
    This is the default design of Excel 365, It is recommended that you go to File>Feedback in Excel to submit your feedback on this issue.
    For more information about the @ operator, please refer to: Implicit intersection operator: @.

    Any updates, please let me know.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.