Sorry for the misunderstanding but I wish to refresh access data in excel,
not the other way around. If I have a password on the access file, I am
prompted for it in excel.
Hi,
Ok, then you can try to check "Save Password" option in External Data range
properties dialog (menu Data-Import external data)
Or perhaps better as in Excel newsgroups
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.