Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate source data on auto refresh
When I open a workbook, data is automatically imported into the worksheet.
How do I locate the source of the data? Where might the path be located for the source data, and how do I change it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate source data on auto refresh
hi
not sure...guessing here but... open the vb editor(alt+F11). in the project window(far left), expand your project(file). click ThisWorkbook. look for an workbook_open macro. you might learn something there. another hunch..... right click the data range and see if on the pop up is listed "edit query". if so, click it which should bring up the MSQuery dialog. on the tool bar, click SQL. this with give you your path, fields and data source. if neither of these work....post back with more info. regards FSt1 "medirate" wrote: When I open a workbook, data is automatically imported into the worksheet. How do I locate the source of the data? Where might the path be located for the source data, and how do I change it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto refresh data once a day? | Excel Programming | |||
pivot table source data expand to new entries when refresh? | Excel Discussion (Misc queries) | |||
Excel 2007 external data source extend table refresh | Excel Discussion (Misc queries) | |||
How to refresh a pivot table that uses changing source data | Excel Programming | |||
How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions |