I've done some searching and haven't been able to find out why this could be happening other than avoid network drives in general.
A tedious task that befalls many Quick Books users is getting data from accounting reports into other spreadsheets.
You can observe in the picture below that selected cell “Garry Lopase” express a link in the formula bar, which expresses that the source of the cell “Garry Lopase” is cell C4 which is in Sheet1 of Book1 workbook.By doing this, your Word document will be updated whenever the Excel file is modified and stay current with any changes.A snapshot of the Excel file containing the spreadsheet and chart will be embedded in your document and it should now look like the following: If you want the Excel spreadsheet and chart to update in your Word document whenever a change is made to the Excel file, you can insert the Excel file using linking and embedding.Step 3: An Edit Links, dialog box, will open, which will show you all the links present on your current sheet. Step 4: The moment you click on the link that you want to delete, all the buttons to the right-hand side of the window will get activated like, Update Values, Change Source, Open Source, Break Link, Check Status. It informs that if you break the links the formula and external references will convert to the existing value of the cell. As the intention of this article is to break links so that we will go with Break Links. Once you break link it can not be undone, so if you want, save a version of the file with a new name. Step 6: Remember in step 1 when the cell “Garry Lopase” was selected it shows the source/link/formula in the formula bar.