Apr 06 2022 02:59 AM
Dear all,
I have been using this formula for years, as part of some macros
I have the feeling that the latest Microsoft updates somehow "Blocked" this formula and now I am getting an error.
=IFERROR(@INDEX(sheetlist,ROW()),"")
Any insight on what may have happened and how to solve this issue?
Many thanks in advance,
Alejandro
Apr 06 2022 03:07 AM
@aparra123 What error? what Excel version are working in?
Tried the formula in a new worksheet, using the latest Excel version. No problem, though you don't need the @-sign.
Apr 06 2022 03:07 AM
We'd have to see (a copy of) the workbook...
Apr 06 2022 07:06 AM
@Riny_van_Eekelen thanks for your response.
to this formula; =INDEX(sheetlist,ROW()) I am getting the error: #BLOCKED!
Apr 06 2022 07:09 AM
Here is Microsoft's list of possible causes: How to correct a #BLOCKED! error