Forum Discussion

Andrew Ravesi's avatar
Andrew Ravesi
Copper Contributor
Jul 18, 2018

Named Range Error

Hello,

 

I have a fairly large excel document that starting complain recently when I open it. It says "We found a problem with some content in FILENAME.xlsx. Do you want us to try to recover as much as we can?" I click yes and it repairs the document and opens giving me another message.

 

It says

"Excel was able to open the file by repairing or removing the unreadable content.

Removed Feature: External formula reference from /xl/externalLinks/externalLink78.xml part (Cached values from external formula reference)
Removed Records: Named range from /xl/workbook.xml part (Workbook)"

 

I'm forced to save this as a new file every time and I keep getting the same error when I open it. How can I find specifically what named range and external link is causing the issue?

Resources