| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
External Data Source from Excel Workbook with names
Hi, I have a workbook with four tables in four sheets. Each table's name is
defined as Example "=Sheet1!$A$1:INDEX(Sheet1!$H:$H,COUNTA(Sheet1!$A: $A))" so that the name includes newly added data. My question is, When I try to access this workbook as an external data source and select the workbook, it does not show me the defined names . What is the solution. I am using Excel 2000 Thanks Fowmy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot find source of external workbook links | Excel Discussion (Misc queries) | |||
| Excel 2000: Changing path of an external data source | Excel Discussion (Misc queries) | |||
| Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
| Update External Data source from Excel sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
