<div>
I have never had to do this. &nbsp;When you open the linked spreadsheet, Access retrieves the data so it is already &quot;fresh&quot;. &nbsp;Are you talking about making the spreadsheet run its calculations? &nbsp;In that case, you would need to automate Excel. &nbsp;So you would have Access use VBA to open excel and run the function to recalculate the spreadsheet. &nbsp;Sorry, I don't have code handy. &nbsp;Since I work with Access rather than Excel, when I need to do some Excel automation, I open Excel and turn on the macro recorder. &nbsp;Then I try to perform the task I need to automate. &nbsp;I then copy the code generated by the macro recorder and fix up the references so it will run in Access.
</div>


I have never had to do this.  When you open the linked spreadsheet, Access retrieves the data so it is already "fresh".  Are you talking about making the spreadsheet run its calculations?  In that case, you would need to automate Excel.  So you would have Access use VBA to open excel and run the function to recalculate the spreadsheet.  Sorry, I don't have code handy.  Since I work with Access rather than Excel, when I need to do some Excel automation, I open Excel and turn on the macro recorder.  Then I try to perform the task I need to automate.  I then copy the code generated by the macro recorder and fix up the references so it will run in Access.

<div>
<div class="content wysiwyg-content">
Thank you for looking at my question,<br />
<br />
I am putting a form together in an Access 2013 database that will enable user(s) to open report(s) via button click.<br />
<br />
The tables/queries behind the reports are linked tables from Excel spreadsheets.<br />
<br />
I would like the button click to refresh the relevant linked table(s) before opening the report to ensure that the data in the report is current.<br />
<br />
How do I do this please using VBA?
</div>
</div>


Thank you for looking at my question,

I am putting a form together in an Access 2013 database that will enable user(s) to open report(s) via button click.

The tables/queries behind the reports are linked tables from Excel spreadsheets.

I would like the button click to refresh the relevant linked table(s) before opening the report to ensure that the data in the report is current.

How do I do this please using VBA?

MS Access VBA to Update Linked Tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.