Forum Discussion
Linking Excel to Word - issue saving the word document
Hi
I have an excel workbook that I have linked to a word document. The word document is our annual financial report and there are multiple sheets in the excel that are linked to the document. They are mostly working fine with the exception of 2 sheets.
When I link the info on these sheets to the word document, the word doc will no longer save, it just permanently has the status saving. If I delete the links for these I can again save the document. These 2 sheets are linked to pivot tables so I don't know if that is causing the issue.
Everything worked earlier in the year, when this problem arose I rebuilt a new excel file in case the other was corrupted. Also if I link these 2 sheets to a fresh word doc that won't save either.
Any ideas / solutions on what might be my
7 Replies
- 30 rows and 50 rows on the 2 sheets. Using classic pivot table
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.
