Data Mesh

PeggyLang

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?

Paul Newcome

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.

Paul Newcome

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?

PeggyLang

Currently they are cross sheet references.

I would use the DataMesh to create cell inks.

Paul Newcome

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.