Unlock table cells and allow writing to linked spreadsheet

00:04

You can also make changes to the table in the drawing

00:08

and then push those changes back to the Excel spreadsheet.

00:12

But before you can do that, you must enable this capability

00:17

first, you must unlock the table cells so that you can make changes.

00:22

By default table cells linked to data are locked.

00:27

In order to be able to change the data.

00:29

You must unlock those cells.

00:33

When you select the table and then hover the cursor over its cells.

00:37

You see a lock badge adjacent to the cursor

00:41

along with a tool tip that shows information about the data link.

00:46

This tool tip also indicates the current lock state

00:54

to unlock individual cells,

00:57

select the cell.

00:59

Then on the table cell contextual ribbon

01:02

in the cell format panel,

01:04

expand the cell locking split button and choose unlocked.

01:10

Now when you hover the cursor over that cell,

01:13

the tool tip indicates that the data cell is unlocked.

01:18

But when you move the cursor over any other cell,

01:22

the tool tip indicates that the cell is locked

01:28

to unlock the entire table.

01:30

Click the upper left corner of the table to select all the cells in the table.

01:36

Then in the ribbon,

01:38

expand the cell locking split button and choose unlocked.

01:43

Now when you hover the cursor over any cell,

01:47

the tool tip indicates

01:48

that the data link cell is unlocked.

01:54

Next, you must enable the ability to write back to the Excel spreadsheet.

01:59

With the table already selected

02:02

on the table cell, contextual ribbon

02:04

in the data panel, click link cell

02:08

to open the modify Excel link dialogue

02:12

in the file group box. The field already includes the path to the Excel spreadsheet,

02:19

click the arrow in the lower right to expand the dialogue box

02:24

in the cell contents group box.

02:27

Select allow writing to source file

02:31

and then click OK

02:33

to close the dialogue.

02:37

There is another way to reach this dialogue box

02:40

press escape to deselect the table.

02:43

Then on the annotate ribbon

02:45

in the tables panel, click link data

02:49

to open the data link manager dialogue

02:53

select Excel data link one

02:56

which is the link to the Excel spreadsheet.

02:59

And then right click to display a shortcut menu

03:03

note that you can rename the data link. If you wish to give it a more descriptive name

03:09

to edit the datalink settings, click edit,

03:13

this opens the same modify Excel link dialogue.

03:18

Since you have already changed the setting to allow writing to the source file,

03:22

click cancel to close this dialogue

03:25

and then click cancel again to close the data link manager.