I have successfully established a link between two cells of two different
workbooks in Excel. I need to be able to just copy and paste in order to
change my source data when I am updating my figures. When I copy and paste
the new sheet into my source sheet, the linked cell shows "0" instead of the
updated number. Is there a way I can prevent this from happening or can I
create a data connection for one cell in particular? Thanks.