Hello, I have a locked spreadsheet and I want to create a new spreadsheet with the data from the locked spreadsheet. But when I linked the data using the paste link option and I sort my data (8000 entries) I get the following error Inconsistence Calculated Formula. I have tried to turn this off in the FILE>OPIONS>PROOFING>AUTOCORRECT OPIONS



I am using this formula to link the cells ='[workbook_SOD.xlsx]worksheet'!I15

I removed the table, but after half a day of work on the spreadsheet the data I have entered into my spreadsheet is all mixed up.

Its to do with sorting but I cannot pin point when it messes up the data