Forum Discussion
Workbook Keeps Asking to Update Links - Workbook Contains No External Links
When I click on Cell A1 --> Data Validation, the prompt informs me that cell A1 allows any value.
Also, I can enter the value "123" that you entered in your screenshot. You can still see the "Enable Content" prompt in my screenshot below.
Is there something wrong with my version of Excel? Thanks.
I checked on another PC - behavior is approximately as in your case. Nonetheless, if unzip your file and check xml inside - it has 4 external links and lot of related data, it looks like they are connected to data validation.
I can't say exactly why it's so. Practical step - if you clean cell A1 (replace it by any empty cell), external references disappear and file works without errors.
How do I unzip an Excel file and check the XML inside? I didn't know you can unzip an XLSX file. I am asking because I would like to identify and correct this issue in my other files as well, thanks.