Dependencies in a workbook

[viktiw]

Hi everyone,
i have a workbook with 20 worksheets. All worksheets have dependency.
Means they have formulas and data getting from other sheets.
Is it possible to cplot or a get a sequence/flow chart on how data is travelling or being used through a macro ?
Any other suggestion is also welcome.

regards,
vik

 

[GraH - Guido]

In Office 2016 you have the workbook analyzer (in the Office Tools). It will auto-document all the formulas used in the workbook and group them per function type, highlight the formulas returning errors, values and text. Grouped per worksheet, and more... I believe dependencies are also shown.
I'm not aware if this exists for earlier versions.

 

[GraH - Guido]

In Office 2016 you have the workbook analyzer (in the Office Tools). It will auto-document all the formulas used in the workbook and group them per function type, highlight the formulas returning errors, values and text. Grouped per worksheet, and more... I believe dependencies are also shown.
I'm not aware if this exists for earlier versions.

Sorry, I confused with Spreadsheet compare. That it is the Office Tools.
I was actually referring to this:
https://support.office.com/en-us/ar...-inquire-5991e8fa-f1c1-401a-ae3f-469384ae3e3b

 

[viktiw]

Hi G.
That was very helpful.
Thank you.

Regards,
Vik