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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
Excel VBA - Problem with Closing Print Preview 0
Excel 2003: Match Names; View Unfound Matches? 1
Can I import text file of cash flow to excel file then use formula 1
Create Flow Chart using Excel VBA 2
why do print range erase in Excel when import data from access 1
Attendance Data 3
Collecting data from Excel form 4

Back
Top