Skip to main content
Question

Bot is adding @ symbol to formulas when running, how to prevent/remove?

  • November 12, 2024
  • 1 reply
  • 73 views

Forum|alt.badge.img+1
  • Cadet | Tier 2
  • 2 replies

I am trying to add a formula an Excel workbook using AA, but the bot adds the @ symbol making it not work correctly.  Is there a way to use the Set Cell Formula to not include the @ symbol when the bot runs?  

=FILTER(UNIQUE($sMasterDataTabName$!F:F), (UNIQUE($sMasterDataTabName$!F:F) <> 0))

 

Turns into


=@FILTER(UNIQUE($sMasterDataTabName$!F:F), (UNIQUE($sMasterDataTabName$!F:F) <> 0))

1 reply

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+14
  • Automation Anywhere Team
  • 869 replies
  • November 13, 2024

Looks like something new that Excel is adding. I also got the “@” and when I went to edit it out, I saw this message:

Apparently there is nothing to worry about.

The “Learn more” button goes here:

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34?ns=EXCEL&version=90