I get the error message below when trying to open up one of my excel reports. My question is how can i find out what the Named Range, Cell or Shared Formula was removed or caused the error. I'm not a VBA expert so any help would be greatly appreciated.
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Records: Named range from /xl/workbook.xml part (Workbook)
Removed Records: Cell information from /xl/worksheets/sheet3.xml part
Removed Records: Shared formula from /xl/worksheets/sheet3.xml part
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Records: Named range from /xl/workbook.xml part (Workbook)
Removed Records: Cell information from /xl/worksheets/sheet3.xml part
Removed Records: Shared formula from /xl/worksheets/sheet3.xml part