Linking data across multiple open spreadsheets
Does anyone know how to reference data in another open spreadsheet in Zoho Sheet? I've tried using the same format as is used in Excel eg in a cell in Document2, ='[Document1]Sheet1'!a1. An update to cell A1 in Document1 would then be reflected in an open Document2. What path should I use to access Document1? Can Zoho do this?