Forum Discussion

Deleted's avatar
Deleted
Feb 06, 2020

Implicit Intersection is ruining my formula

I have a formula which writes to a cell using a macro. The formula contains sumproducts in order to pull data from an external spreadsheet.

 

When I write the formula normally it works fine, however, it leaves links in the file which give you a pop-up warning when you open the file. I'd rather this wasn't there. So I have a macro write the formula in after a button click.

 

However, excel is adding the Implicit Intersection @ symbol everywhere I have a sumproduct, rendering them useless, and returning a #VALUE error.

 

Is there any way to stop excel adding these @'s in?

excel
Formulas and Functions

2 Replies

  • Savia's avatar
    Savia
    Iron Contributor
    Feb 06, 2020
    There's a setting in Excel Options => Formulas to disable "Suggest formula variations that are supported by older versions of Excel".
    • Deleted's avatar
      Deleted
      Feb 06, 2020

      Savia I see that option, but it makes no difference to the behaviour whether checked or unchecked.

Resources