Hello,
I have an Access Database where several excel workbooks are linked to MS access as Tables basically for the ease of use, when new data is fetched gets updated into access by Refresh.
The problem is when the database is open by another user , the excel sheet can not be updated. Is it...