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, howeve...
excel
Formulas and Functions
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