Excel Workbook link

%3CLINGO-SUB%20id%3D%22lingo-sub-2993116%22%20slang%3D%22en-US%22%3EExcel%20Workbook%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993116%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20a%20way%20to%20access%20date%20from%20a%20different%20workbook%20with%20various%20sheets.%20is%20there%20a%20formula%20that%20links%20to%20a%20different%20workbook%2C%20but%20selects%20a%20different%20sheet%20according%20to%20the%20function%3F%20For%20example%2C%20workbook1%20has%203%20sheets%3A%20A%2C%20B%2C%20and%20C.%20workbook2%20has%20a%20reference%20to%20workbook1%20in%20cell%20A1%2C%20but%20selects%20the%20sheet%20as%20named%20in%20cell%20B1%3A%20A%2C%20B%2C%20or%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2993116%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2993290%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993290%22%20slang%3D%22en-US%22%3EThe%20INDIRECT%20function%20allows%20that%2C%20but%20I%20would%20not%20recommend%20using%20it%20as%20it%20only%20works%20when%20both%20workbooks%20are%20open%20in%20Excel.%20Have%20a%20look%20at%20Data%2C%20Get%20Data%2C%20From%20File%2C%20From%20Workbook.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2993537%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2993537%22%20slang%3D%22en-US%22%3Ethanks%2C%20but%20i%20would%20like%20to%20find%20another%20alternative.%20but%20this%20is%20what%20i%20am%20trying%20to%20come%20away%20with.%20I%20do%20have%20a%20query%20connection%20for%20now%2C%20but%20it%20takes%20up%20too%20much%20space%2C%20and%20i%20have%20to%20have%20a%20connection%20for%20every%20sheet.%20it%20also%20takes%20too%20long%20to%20refresh.%3C%2FLINGO-BODY%3E
Occasional Contributor

I am looking for a way to access date from a different workbook with various sheets. is there a formula that links to a different workbook, but selects a different sheet according to the function? For example, workbook1 has 3 sheets: A, B, and C. workbook2 has a reference to workbook1 in cell A1, but selects the sheet as named in cell B1: A, B, or

2 Replies
The INDIRECT function allows that, but I would not recommend using it as it only works when both workbooks are open in Excel. Have a look at Data, Get Data, From File, From Workbook.
thanks, but i would like to find another alternative. but this is what i am trying to come away with. I do have a query connection for now, but it takes up too much space, and i have to have a connection for every sheet. it also takes too long to refresh.