Forum Discussion
"You can't change part of an array." but source cannot be located
My source database is locked from sorting or filtering by the 'you can't change part of an array' error message, but I cannot find the array formula that it is referencing in order to correct it. ...
If you are on Pro version it shall be Inquire available, you may activate it from File->Options->Addins->COM addins
Within Inquire tab is Workbook Analysis, it will show you lot of information includes locations of the array formulae.
Thanks Sergei. The Inquire add-on worked perfectly and took me right to the errant array formula.