countess1234
Computer
- Jun 25, 2002
- 1
I wrote a simple DLL with a function that I use in Excel for retrieving data from an Access Database.
The problem is that when the data changes in the Database, it is not reflected in the Excel spreadsheet. Re-Calculating does not work (F9). I either have to re-enter the variable in the function or re-enter the entire function in order to get it to reflect the updated values in the database. Even if I close and re-open the worksheet it still displays the old data.
I need it to respond the the Auto Calculate or atleast refresh on Mannual Re-Calculate.
Any Ideas.
Thanks.
The problem is that when the data changes in the Database, it is not reflected in the Excel spreadsheet. Re-Calculating does not work (F9). I either have to re-enter the variable in the function or re-enter the entire function in order to get it to reflect the updated values in the database. Even if I close and re-open the worksheet it still displays the old data.
I need it to respond the the Auto Calculate or atleast refresh on Mannual Re-Calculate.
Any Ideas.
Thanks.
