Data Mesh
I have inherited a couple of worksheets. One of the sheets is basically the dataset and the other is MOSTLY a sheet FULL of links - individually set up links. It works fine to the best of my knowledge, however, I'm wondering if there is something to gain from setting up a datamesh? Are there advantages to datamesh over the already setup sheet full of links?
Best Answer
-
It should be slightly more efficient on the back-end with the DataMesh creating cell links because cell links require less processing than cross sheet references, but if you are not experiencing any performance issues, I wouldn't honestly just recommend leaving it alone if it is working alright.
Answers
-
By links do you mean cell links or cross sheet references? Would you use the Data Mesh to create the cell links or would you use it to push the static data on a regular basis?
-
Currently they are cross sheet references.
I would use the DataMesh to create cell inks.
-
It should be slightly more efficient on the back-end with the DataMesh creating cell links because cell links require less processing than cross sheet references, but if you are not experiencing any performance issues, I wouldn't honestly just recommend leaving it alone if it is working alright.
