Forum Discussion
Linking Excel to Word - issue saving the word document
how many rows of data are in those two sheets
are you using the classic pivot table or power pivot
Can you elaborate when you state:
I have an excel workbook that I have linked to a word document.
how did you link the workbook, and how many workbooks have links to one word document? (this is important because each time a file process accesses another file it would need a time slice thread) so if you have 100 excel workbook links to one word document it would mean a chunk of hardware resource being spent on each link. I would probably suggest doing a power query to each workbook data set in one excel workbook, and create all your pivot tables in that one workbook then link that one workbook to your one word document so there wouldn't be file access conflicts because each link updates x number of times x 100 links that would create a resource conflict.
Thanks for getting back to me. I have 1 excel workbook and 1 word document. They are linked via Copy and Paste link, Excel Worksheet Object, in the word doc.
There is only one Pivot table in the excel workbook that is linked to the P&L and BS sheets that are causing the issue.
Some of the data in the sheets that are linking fine to the word doc are linked to the P&L and BS sheets.