Nov 21 2018 05:32 AM
Hey. I've been struggling for a few days with a file that throws the following error : https://imgur.com/a/C4g4yBX . Initially I found the function with that name defined in a class. I deleted EVERYTHING pertaining to that particular function. Nothing else in this excel workbook/code contains the "isformula" string. Still, I get the same error. I tried searching again both in the code and in the workbook, no results were found. I tried searching in conditional formatting to see if I can find that function, but didn't find it. An expedient solution was saving the file in .xlsm instead of .xlsb (which was the de facto format for this specific file), but this is not acceptable. Can someone give me any ideas where to look further? Thanks!
Nov 21 2018 08:18 AM
Nov 22 2018 04:10 AM
Thanks for helping, Jan! I don't have any hidden sheets and I can't find any XL4 macro traces. BTW, I use Office 365 (just as a reference). I still don't get why saving the file as .xlsm instead of .xlsb solves the problem...
Nov 22 2018 05:38 AM
Nov 22 2018 06:45 AM
Thank you, Jan. But this is a strictly confidential file (annoying, I know). I wish I could just send it to more capable minds, but the internal regulations prevent me from doing so. Sorry.
Nov 22 2018 07:51 AM