Excel2013 edit XLS version of the file (for compatibility), when saving tips


Me try through the following steps, save when question remains:
All cells in the document text, formula are empty
All the cell selection sheet, delete cell
Create a new empty sheet, delete the original sheet

Now is an empty document, save time also complains that anyone I encountered this situation?
Although the click the "continue" to save the document, but each save will pop up the message, want to know why, please comment

CodePudding user response:

Click Data - & gt; Edit External Link you will see that all references to External files, choose to break the source, will place for External links

In addition, if don't damage, record the external file name, then find and select all the workbook, only to find the formula, will find reference

CodePudding user response:

Data under the menu option, didn't see you said only an edit link, and cannot be gray, I deleted all the sheet, a new blank sheet, save or prompt question information,