Ok, small issue. I have an Access database that pulls data from another department's Excel spreadsheet. My database seemed to be locking their spreadsheet any time someone ran a query that drew data from the link, so I created an intermediatary spreadsheet that basically links to all of the cells on theirs via "=[TheirSpreadsheet]Sheet1!A1" type formulas in every cell.
Currently, I find that I must open my spreadsheet, Update Links, and then save and close it in order to update my linked table in Access. Is there a way to have Access automatically refresh the spreadsheet links whenever I open the related linked table in Access?
For context, I took a VBA class, but I reeeeeally suck at it
.
Currently, I find that I must open my spreadsheet, Update Links, and then save and close it in order to update my linked table in Access. Is there a way to have Access automatically refresh the spreadsheet links whenever I open the related linked table in Access?
For context, I took a VBA class, but I reeeeeally suck at it
.
