Update a table when extracted and linked data changes

00:04

The lengths of the pipes are being read directly from the drawing.

00:07

While the cost per foot for each type of

00:10

pipe is being read from the Excel spreadsheet.

00:13

If you modify the pricing information in the Excel spreadsheet or

00:18

edit the drawing to change the length of the pipes,

00:21

you can update the table to reflect those changes

00:24

to see this in action.

00:26

Open the Excel spreadsheet

00:30

change the cost of the water lines from 650

00:34

to 750

00:36

and save your changes.

00:39

Then switch back to the drawing

00:42

on the status bar right. Click the data link tool and choose update all data links.

00:50

The table immediately updates to reflect the change.

00:53

Switch back to Excel,

00:56

change the cost back to 650

00:59

click save.

01:01

Then back in the drawing.

01:04

Update the data links again

01:08

on the insert ribbon

01:10

in the reference panel,

01:12

click the dialogue box launcher to open the external references palette

01:18

in the pallet

01:19

right.

01:19

Click the civil lines reference and select open to open

01:24

the external reference containing the lines representing the pipes.

01:29

Select the water line on the left side of the drawing,

01:33

click and drag the upper grip to increase the length of that line

01:38

press escape to deselect the poly line

01:41

and then save the drawing.

01:45

When you switch back to the civil plan drawing,

01:48

you should see a notification balloon

01:51

indicating that the external reference has changed

01:55

clear the compare the changes check box

01:58

and then click the link in the balloon to reload the X

02:02

ref

02:04

then right, click the data link tool and choose update all data links.

02:10

As soon as you do the length value updates

02:14

and the costs are recalculated.

02:17

As you have seen,

02:19

you can create tables that combine data extracted from properties

02:22

in the drawing with data in an Excel spreadsheet,

02:26

perform calculations on that data

02:29

and update the table to reflect changes made to

02:32

the drawing or to the data in the spreadsheet.