Hello all, Im trying to get Excel to grab data from a specific cell on an
external spreadsheet through a pastlink and populate that data to 2nd
spreadsheet that will be tag as a read-only document (for view purposes
only). The data in the first sheet will change when new lines are inserted
above or are placed at the original cell location.

example: First spreadsheet cell A5 has the number 5 in it, that data is
pastelinked to a second (read only) spreadsheet where it is displayed. Now at
row A4 I insert 4 new rows to allow room for the new data that will be copied
here. The new data in the same A5 cell is 10 and needs to display 10 on the
second spreadsheet.

How do I stop excel from following the first A5 and populating that data on
the second external spreadsheet. I only want it too give me the data that
will be in the A5 cell even after the lines are inserted above. I have tried
using the =$A$5 but when the lines are adding the cell that carries the
formula adjust to the new lines add and the calculated cell reads =$A$9. So
is there away to lock-in on a specified cell and it not adjust to the new
inserted lines.

Thanks

In need of help