Thread: [Solved] Linking Data
View Single Post
 
Old 05-04-2015, 03:14 PM
quicky quicky is offline Windows 8 Office 2013
Novice
 
Join Date: May 2015
Posts: 3
quicky is on a distinguished road
Default 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
Reply With Quote