I want to use Excel as a live database.
There is a front end java application which is reading the excel file as a database.
While this process is on I want to add more data into the database.
I have accomplished this using VBA and sharing the excel sheet.
However the newly added data appears in the backend (excel sheet) but is not read by the java application.
Any suggestions ?
Please consider this as urgent.