I have a spreadsheet that is created via an export from Crystal reports. The xls is fine when I go to open it. I have another spreadsheet that has a data connection to the exported sheet. When looking at the data from the connection all data in column o is cleared out except the header. I have recreated this with several test sheets and can't seem to find the issue. I am attaching a test sheet and if you create a data connection to that sheet and just bring over all data it will drop the data in column o.