Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Recovery error message appears for macro enabled shared excel workbook

0

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

How should I deal with this issue?

Answer
Discuss



Answer the Question

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