problem with a linked Excel table

A

Alex

I have a linked Excel table.

When this Excel worksheet is opened I cannot use queries
associated with this getting an error message that it's
opened.
Even if it's closed but some application uses a query with
this Excel table and another app tries to open a report
with the query, which uses this Excel table, I have the
same error message.
The error message is as follows:

The Microsoft Jet database engine cannot open the
file "Excel table.xls". It is already opened exclusively
by another user, or you need permission .

How could I avoid this situation?

Thanks
 

Ask a Question

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.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
Embedded Excel into Word with Tables 0
Dealing with the error: unable to filter on excel hc home school 0
Autonumber field in Excel that behaves the same as Access 0
Linked Excel tables opened exclusively 4
Table linked to Excel 2
Jet ending cannot open file 0

Top