Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel print data flow diagrams of an existing excel database?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel print data flow diagrams of an existing excel database?
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. "Amir" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use excel to create process flow diagrams? | Excel Discussion (Misc queries) | |||
How do I label flow connectors in and excel flow chart? | Excel Discussion (Misc queries) | |||
How to create lists of data quickly from a pre-existing database | Excel Discussion (Misc queries) | |||
how do I print mailing labels from an Excel database? | Excel Discussion (Misc queries) | |||
How do I get data to automatically flow to another sheet? excel 20 | Excel Worksheet Functions |