Forum Discussion
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
- AunSyedShahCopper ContributorI Don't think so it is supported on android
- tinkertailor47Copper ContributorI suspected it was not supported but wonder if anyone can suggest an alternative approach to achieve the same result?