Forum Discussion

tinkertailor47's avatar
tinkertailor47
Copper Contributor
Jan 28, 2020

Linking data between files in Office 365 for Android

I run a business that relies on excel spreadsheets.

I create an enquiry file of which the front summary page is loaded with all the information pertaining to a single job. In separate pages subsets of the information are relaid out to create a set of documents for printing, such as order, delivery note, invoice, etc. This works very well.

In addition, there is one page which creates 3 separate arrays of data for transfer to 3 other files. One is a register of all jobs with their status, one is a list of orders issued by order number, and the third is an accounting file.

On my laptop I can copy the whole of each array into the appropriate cells in the other documents by highlighting the cell range in the destination document, clicking on '=' symbol, then selecting the array cells in the source file followed by Ctrl, Shift, Return.

Any subsequent changes in the master enquiry file can then be updated in each of the 3 summary files using DATA, Edit Links, Update in each one.

Is it possible to duplicate this in office 365 for Android as I usually see that links to other files are always disabled?

2 Replies

    • tinkertailor47's avatar
      tinkertailor47
      Copper Contributor
      I suspected it was not supported but wonder if anyone can suggest an alternative approach to achieve the same result?

Resources