Forum Discussion
excel help with microsoft 365
when i opened my spreadsheet it used to ask to enable active content.
i have a hidden active page that now i cant find, it is an active formula or VB or activeX or macros, that extracts email addresses from another page.
I use =@ExtractEmail(Cell#)
Now, this no longer works, and I no longer get the Enable Active Yes or No upon opening the file.
The formula returns #NAME?
i tried to have excel repair it, and it asks me to repair and save to a new file, it wont save to a new file name either and work.
What am I missing? I went to info, and enabled what I saw, and it still doesnt work.
I tried letting EXCEL repair it and that doesnt work either.
6 Replies
- Shae a sample file with few of a sample data so that we can build formula for you.
Someone saved the workbook not as an xlsm file.
So the VBA code has been deleted from the workbook.
Detlef_Lewin it was and still is saved as a XLSM
and all of the data before last week is still extracted and showing
but any new data added, it returns #NAME?
- if not works now,how about discuss the specific problem?
Maybe it can be solved by another way.- if not works now? i explained above that it doesnt work.
