Is it possible to make a general dictionary - a reference book for "office" documents?

Question

Documentation

There is a project which documentation is made in Visio, Excell and Word.
All this lies on the Share point.
Excell is generally friendly with Visio - you can store the properties of diagram objects in tables, for example.
But is it possible to make Word and Excell friends in the same way?
Tasks:
1. Make a list of terms and/or descriptions. It will be stored in tablets, it will be mentioned in Word.
2. Describe parts of the Visio diagram in Word so that the data of this diagram and / or the image changes "by itself".

Answer 1

If you really need to do what you described and do it repeatedly, then you have completely wrong choice of documentation technology.
What you described is the so-called. reuse content. It is implemented in DocBook and DITA standards. However, these standards have nothing to do with Word, Excel, Visio, and the like.

Answer 2

SharePoint has such a thing as https://docs.microsoft.com/ru-ru/sharepoint/manage...
Actually, you can insert all your terms from this dictionary.
Further, it is not clear what you mean by signs?
If these are list items (Fields) or document libraries, then they are perfectly embedded in documents.
By the way, you can create a document template for the library and automatically fill it in at the time of creation.
In Word there is such a thing as external data sources, implement Excel for yourself.
As for the visio and diagrams, it’s a little unclear, please clarify.
PS I'm really trying to fit an overview of many features into a short answer.