I have created a spreadsheet that uses CSE Formulas and it is working perfectly in Excel 2016. When it is loaded into Office 365, most of the CSE formulas are working however one is not.
So I enter in data in one worksheet and the CSE formulas all populate in that worksheet. I go to the other worksheet and those CSE Formulas are all populated then I go to the last worksheet and there are no values for the CSE formulas.
Shift F9 doesn't work. All that works is copying down the formula again.
When I copy the formula down again all the values show up, so then I go back to the original sheet and add another piece of data, all the CSE Formulas in that worksheet populate, the next work sheet populates but the last sheet doesn't. And it has removed the values from the last time I copied the formulas down again.
I hope this makes sense to someone..
Automatic calculation is on.
thanks
This is the formula if anyone is interested...
{=textjoin("," & Char(10), TRUE, IF(ISNUMBER(SEARCH(B2, 'Matrix'!$A$2:$a$356)),IF('Matrix'!$B$2:$MT$356=1,'Matrix'!$B$1:$MT$1,TEXT(,)), TEXT(,)))}
Bookmarks