G
Guest
I have created a workbook where three sheets are from an access database
(Data/Import external data) (in Excel 2002 SP3), and a summary/lookup/filter
page.
I built this workbook on my notebook, working from a copy of the original
database.
Questions:
1. How can I transfer this to my accountant's computer and redirect the the
database to the real one on the office network?
2. I see that Excel grabs the three tables and puts them in "My Data
Sources" if I click "refresh Data". Will it just go to there? Or will it
update from the database itself?
3. If it just updates from "May Data Sources" and that does not update
automatically from the database, how can I update those tables from the
database?
(Data/Import external data) (in Excel 2002 SP3), and a summary/lookup/filter
page.
I built this workbook on my notebook, working from a copy of the original
database.
Questions:
1. How can I transfer this to my accountant's computer and redirect the the
database to the real one on the office network?
2. I see that Excel grabs the three tables and puts them in "My Data
Sources" if I click "refresh Data". Will it just go to there? Or will it
update from the database itself?
3. If it just updates from "May Data Sources" and that does not update
automatically from the database, how can I update those tables from the
database?