Update a linked spreadsheet to reflect table data changes

00:04

Now that you have unlocked the cells and enabled writing to the source file.

00:09

Any changes you make to the table can be exported back to Excel.

00:15

For example, double click, the unit cost for item four

00:21

and change its value

00:23

to 450.

00:25

If you find that the cell is locked, right,

00:28

click to display a shortcut menu and select locking

00:33

unlocked.

00:35

This is the same as using the tool on the contextual ribbon.

00:40

After you change the value,

00:43

close the text editor

00:47

to push the change that you just made back to the Excel spreadsheet

00:51

on the annotate ribbon

00:53

in the tables panel, click upload to source

00:58

the program prompts you to select objects,

01:02

select the table and then either right click or press. Enter

01:08

the program displays an alert balloon to inform you that a data link has changed.

01:15

Click the link in the balloon.

01:18

When you do

01:20

the program indicates that one object was

01:22

found and one object was updated successfully.

01:28

Switch back to Excel

01:30

and reopen the spreadsheet.

01:34

You can see that the cost for item four has changed to 450

01:39

reflecting the changes you made to the table in your drawing.