Forum Discussion
Issue _xlfn.Single and @ being added to formulas - unsupported functions - NOT THE REASON
Excel has recently been adding the @ symbol after saving and reopening the spreadsheet. Examples =@NamedRange =@Iferror(... and even inside the formula =@iferror(index(@indirect(file.xlsx... ...
Katherine, yes, so called implicit intersection '@' was introduced with dynamic arrays in previous year. All details are here Implicit intersection operator: @
Usually it works correctly and could be ignored. An error you have most probably since you used mixed operator like =SingleSource + something. Such errors are also described in above article.
The only way is to re-write such expression differently.
Thank you so much. One formula was just a reference to a named ranged. We have a consultant with the same version of MS Office 365. He is not experiencing the issue at all I will read the article and let you know. Thank you again!!! Katherine Bradford