Updating excel files
Here are some of the reasons why Excel files might not open after an upgrade: Regardless of whether you’re able to spot the exact trigger for the issue, you can try the below mentioned solutions to repair Excel files after upgrade.
You can try the below fixes to repair Excel files after upgrade: As a first step, update your Microsoft Excel and Windows to the latest patch.
To determine whether add-ins are the ones creating the issue, you need to open Excel in Safe Mode and see if it helps.
You can fix the issue by simply restarting Excel 2016.
If it doesn’t fix the issue, you need to repair Excel by following these steps: Note: Remember to upgrade all the Printers Drivers to the latest version from the internet.
So, what we do instead is to access the Access DB through VB and update all the values using ADO.
Before you start, make sure you add the Microsoft Active X Data Object Library to your code.
Search for updating excel files:
Step 3: Now we have the entire table contents in the record set.