#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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.
Last edited by quicky; 05-04-2015 at 10:09 PM. |
#3
|
|||
|
|||
Its to do with sorting but I cannot pin point when it messes up the data
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2013 - linking cell data within a table | jhamblin | Word Tables | 1 | 03-15-2015 01:32 AM |
Linking information | Hinchy | Word | 5 | 09-07-2012 08:11 PM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
Forms - Combo Box Linking data | tomkat | Word | 1 | 04-23-2010 06:28 AM |
linking or something? | boonders | Word | 2 | 01-07-2009 02:12 PM |