Recovery error message appears for macro enabled shared excel workbook


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(legacy share feature) and tried to open again it gives a recovery message as We found a problem with some content in name.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 which the third sheet is the one that is causing the error.

The error message is in xml that looks something like this

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

<recoveryLog xmlns=""><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>

How should I deal with this issue?


Answer the Question

You must create an account to use the forum. Create an Account or Login