J
Jerry Lee
I'm currently performing data analysis on a group of
related Excel spreadsheets that have grown over time.
All of the spreadsheets contain numerous tabs with
multiple references to other tabs and other
spreadsheets. Performing analysis on these spreadsheets
has been difficult because of the labyrinth of complex
data relationships.
Can someone advise on whether there is an Excel tool
available in the marketplace that can do what 'Enterprise
Manager' does for a SQL database? Basically, I'm looking
for a tool that can document the data relationships
within a set of spreadsheets either graphically or in
text format so that I can have a roadmap to help me
analyze the data.
Any advice would be much appreciated!
Regards,
Jerry Lee
related Excel spreadsheets that have grown over time.
All of the spreadsheets contain numerous tabs with
multiple references to other tabs and other
spreadsheets. Performing analysis on these spreadsheets
has been difficult because of the labyrinth of complex
data relationships.
Can someone advise on whether there is an Excel tool
available in the marketplace that can do what 'Enterprise
Manager' does for a SQL database? Basically, I'm looking
for a tool that can document the data relationships
within a set of spreadsheets either graphically or in
text format so that I can have a roadmap to help me
analyze the data.
Any advice would be much appreciated!
Regards,
Jerry Lee