different links for each sheet
i have a workbook with 5 worksheets and i want to link 5 different links to
those each worksheet. i tried updating the link sheet by sheet but its updating all the sheet... can anyone help me with this...thank you in advance |
different links for each sheet
What would you be linking to and how are you creating those links?
Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 07:52:28 -0700, ganga wrote: i have a workbook with 5 worksheets and i want to link 5 different links to those each worksheet. i tried updating the link sheet by sheet but its updating all the sheet... can anyone help me with this...thank you in advance |
different links for each sheet
the link file also excel.but different workbooks.
eg. link workbook 1 in sheet 1(workbook A) link workbook 2 in sheet 2(workbook A) and so on... "Gord Dibben" wrote: What would you be linking to and how are you creating those links? Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 07:52:28 -0700, ganga wrote: i have a workbook with 5 worksheets and i want to link 5 different links to those each worksheet. i tried updating the link sheet by sheet but its updating all the sheet... can anyone help me with this...thank you in advance |
different links for each sheet
You must enter your linking formulas in each sheet.
Make sure the sheets in WorkbookA are not grouped when entering the formulas. WorkbookA sheet1 =[workbook1.xls]Sheet1!$A$1 WorkbookA sheet2 =[workbook2.xls]Sheet1!$A$1 WorkbookA sheet3 =[workbook3.xls]Sheet1!$A$1 If you go to EditLinks you will see the three workbooks you have linked to. If you change source workbook1 to source workbook5, it should affect only the one link on WorkbookA sheet1 BUT!! when you change the source workbook you will also have to change the sheetname in your formula if that sheetname does not exist in the new source workbook. Easy, isn't it<g Gord On Tue, 30 Jun 2009 09:19:01 -0700, ganga wrote: the link file also excel.but different workbooks. eg. link workbook 1 in sheet 1(workbook A) link workbook 2 in sheet 2(workbook A) and so on... "Gord Dibben" wrote: What would you be linking to and how are you creating those links? Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 07:52:28 -0700, ganga wrote: i have a workbook with 5 worksheets and i want to link 5 different links to those each worksheet. i tried updating the link sheet by sheet but its updating all the sheet... can anyone help me with this...thank you in advance |
All times are GMT +1. The time now is 11:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com