Excel

Hi Nasima

Yes data from one spreadsheet can be linked to another spreadsheet. If it is a block of data the easiest way is as follows:

Open both spreadsheets
Copy the block of data from spreadsheet 1
Select a cell in spreadsheet 2
Choose Paste Special
Press Paste Link button

Then if data is deleted from spreadsheet 1 it will display as 0 in spreadsheet 2.

Also when opening spreadsheet 2 on its own you will be prompted with Options, choose Enable Content to display the latest changes made to spreadsheet 1.

If the data is scattered then copy / paste link wont work.
You can start in spreadsheet 2 and use the following method:

Select a cell
Press =
Navigate to spreadsheet 1
select the cell you wish to link
Press Enter

You will have to do this for all the date you wish to link.

You can also use this method to linka block of cell. But you have to remove the $ signs around the cells reference before pressing Enter. Then the linked cell can be copied down and across.

Please let me know if that helps Nasima

Regards
Doug Dunn
Best STL