Hello,

I have a database that has 5 linked excel files. From there I have a form that runs many different queries. I have a macro that updates the queries by running them and closing them. Occasionally I update the excel files and was wondering if there is a way to show which records were added to the linked excel files. In other words, I need to display the new records that were updated. Does anyone have any solutions? Thank you for your help in advance.

If you want to track changes when those changes are made through forms in Access, you would have to set up an audit trail. This link has one way of doing it.http://allenbrowne.com/AppAudit.html

Excel has a tracking function already: Tools: Track Changes