Paste Links fails

  • Thread starter Thread starter Geoffrey Kaduma
  • Start date Start date
G

Geoffrey Kaduma

I'm using Excel 2000 and I paste values, using the Paste
Link option, onto another worksheet in the same workbook.
The problem crops up when I go back to the first worksheet
and change the (original) values and the values in the
worksheet where i pasted them do not change automatically.
What can I do to ensure smooth flow of data between the 2
worksheets?
 
Go to Tools, Options and make sure you have Automatic
selected under Calculation options.
 
Back
Top