Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Access Queries
I have created an Excel spreadsheet that is linked to several Access queries.
It all works fine except: 1. How do you eliminate that annoying message that asks if you want to automatically update the data? 2. If I click yes on that message it only updates the worksheet that is open. The other 15 worksheets are not updated. I am forced to go to each individual worksheet and update them manually. Is there an option or some code that I could put into an event to autmatically update all of the worksheets upon opening the spreadsheet. Note: I am opening the spreadsheet from Access. Any code/advice would be appreciated. Thank you. -- M. Shipp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not all Access queries can be imported | Excel Discussion (Misc queries) | |||
Importing Access Queries | Links and Linking in Excel | |||
Access queries/tables | Excel Discussion (Misc queries) | |||
Workbook with 20+ queries of Access is TOO BIG | Excel Discussion (Misc queries) | |||
queries (sql) in ACCESS help | Excel Discussion (Misc queries) |