Linkage between spreadsheets .... link from file1 sheet3 to file 2 sheet 1

[dwalley]

Hi.

I have a password protected master spreadsheet with 10 worksheet
included, I would like to create another password protected spreadshee
where the viewer may only see the contents of sheet 3 from the firs
spreadsheet.

It is vital that the second spreadsheet is password protected.

Thanks

Dav

 

[Frank Kabel]

Hi
just link the cells from this sheet. something like
=[book1.xls]Sheet3'!A1
in cell a1 of your new worksheet

 

[dwalley]

Frank.

Thanks for your reply, I tried that but it only copied the contents o
cell a1 into my secondary sheet. What I want is the entire contents o
the sheet which currently has 40 rows X 30 columns (this may change).

Dav

 

[Frank Kabel]

Hi
just drag/copy this formula for all rows/columns

 

[Dave Peterson]

You may want to amend the formula slightly:

=if([book1.xls]Sheet3!A1="","",[book1.xls]Sheet3!A1)

Then drag down and drag to the right.

You won't get 0's for those empty cells.