I have several worksheets in .xlsx format that link to other workbooks. Does anyone know why only certain pieces of data link and the others show 0 until I open the source book? I can click on "Edit Links" and update the data, but the cell stays as "0" until I open the source book and everything will show after. These worksheets are exports from Access if that makes any difference.