Questions on Importrange

[Samiam8]

1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault?

2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet 1 (A12) is linked to Sheet 2 (B35) via Importrange. When I import a cell containing "Yes" on Sheet 1 (A12), the cell it is attached to in Sheet 2 (B35) reflects it as "Agree")

 

[Macropod]

This is a duplicate of: https://www.mrexcel.com/forum/gener...-questions/1073587-questions-importrange.html
Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.