can excel print data flow diagrams of an existing excel database?

  • Thread starter Thread starter Amir
  • Start date Start date
A

Amir

I have a school attendance database working on excel. As i did not design the
sheets. I need to find if there is a way for excel to show me any entity
relationships. So I know how and where everything is connected.
 
look for the cells that have formulae and then click on any one cell you
want to check the formula for. go to TOOLS | FORMULA AUDITING | TRACE
DEPENDENTS / TRACE PRECEDENTS.

To select all the cells that have formulae in them, press CTRL+G | Click
SPECIAL | Select FORMULAS | Cick OK.

Hope that helps.
 
Back
Top