Add references to spreadsheets that should go in separated files to main word document


I am preparing a manuscript, with some excel tables embedded in the word document. On each table, bibliographic references appear as numbers, later as endotes in bibliography.

Later I received instructions from editors, so spreadsheets should go separated in files. How can I add them the references?


I would just keep the table in the manuscript and select it and make it hidden text.  When you submit, you might want to  unlink fields (or “removed endnote field codes” from the toolbar) on a copy and then you can remove the “hidden” table. 

Alternatively you can insert the references and hide them if numbered, or omit author and date via edit citation if (Author, YEAR) citation format.