Excel Online - linking sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1570769%22%20slang%3D%22en-US%22%3EExcel%20Online%20-%20linking%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570769%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20use%20Excel%20online%20and%20I%20would%20like%20to%20link%20a%20whole%20worksheet%20to%20another%20whole%20worksheet%20in%20a%20different%20folder.%20So%20far%20I%20am%20only%20finding%20information%20on%20linking%20a%20data%20cell%2C%20not%20the%20whole%20sheet.%3C%2FP%3E%3CP%3EBasically%2C%20I%20want%20to%20take%20a%20contact%20list%20sheet%20in%20a%20large%20workbook%20and%20create%20just%20the%20individual%20sheet%20in%20it's%20own%20workbook%20in%20another%20folder%2C%20but%20would%20like%20the%20data%20in%20the%20master%20sheet%20to%20automatically%20update%20the%20individual%20sheet.%20Can%20I%20do%20that%20without%20doing%20it%20cell%20by%20cell%3F%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1570769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570855%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20-%20linking%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570855%22%20slang%3D%22en-US%22%3EAs%20far%20as%20I%20know%2C%20Excel%20on-line%20does%20not%20support%20external%20(formula)%20links.%3C%2FLINGO-BODY%3E
Occasional Visitor

We use Excel online and I would like to link a whole worksheet to another whole worksheet in a different folder. So far I am only finding information on linking a data cell, not the whole sheet.

Basically, I want to take a contact list sheet in a large workbook and create just the individual sheet in it's own workbook in another folder, but would like the data in the master sheet to automatically update the individual sheet. Can I do that without doing it cell by cell?

Thanks!!

 

1 Reply
As far as I know, Excel on-line does not support external (formula) links.