Recovery error message appears for the shared excel workbook created using macro

I have a macro enabled workbook that is generated using a custom written macro which works fine in an unshared environment, but the moment it is shared and tried to open again it gives a recovery message as We found a problem with some content in xlsm do you want us to recover as much as we can if you trust this source of workbook click yes.

As per my observation, that workbook contains 3 major tabs(sheets), In that the third sheet is the one that is causing the error.

How should I deal with this issue?

Quote from CapG

I have a macro enabled workbook that is generated using a custom written macro which works fine in an unshared environment, but the moment it is shared and tried to open again it gives a recovery message as We found a problem with some content in xlsm do you want us to recover as much as we can if you trust this source of workbook click yes.

As per my observation, that workbook contains 3 major tabs(sheets), In that the third sheet is the one that is causing the error.

How should I deal with this issue?

The error message is in xml that looks something like this

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error437920_02.xml</logFileName><summary>Errors were detected in file 'C:\Users\rar\dev\Lifecycle\Shopping List Split File\Shopping list\Shopping List09-09-2020.xlsm'</summary><removedRecords><removedRecord>Removed Records: Named range from /xl/workbook.xml part (Workbook)</removedRecord></removedRecords></recoveryLog>

Using legacy share option. We have a shared network in which the file resides

Thank you for your help!