Linking Data
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
|