Forum Discussion
Excel inserts '@' Symbol into formulars, which breaks them
I did some more testing myself and found that this only affects files generated in version 2019 of Excel that are then opened in Excel O365.
The formular that I used is not valid in Excel 2019, because this excel version does not support all methods I used I believe. Nevertheless, the formulars can of course still be typed.
I would assume, that once you open the same file in the O365 version of Excel, the formulars would be reevaluated.
My issue seems to be the following: Excel inserts the implicit intersetion operator in O365, because that's how the formular is interpreted in Excel 2019. However the formular only works without the Implicit intersection operator. Is there a way to tell excel in the formular that I do not want the formular to be interpreted as implicit intersection?
FelixRech IN addition to what PeterBartholomew1 wrote, I would do this:
- Open the file in Excel 2019
- Find one of the cells containing the defective formula
- Make sure the entire formula is visible in the formula bar
- Clear all cells you don't want included in a screenshot
- Click Help, Feedback, I don't like something and check the screenshot box and describe your issue. Perhaps even link to this thread here. Leave your email address if you want them to contact you.
