Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating a cell that uses a .NET add-in function
I've created an automation add-in for Excel using .NET. This add-in
contains a function called GetValue. The GetValue function takes two parameters, hits a SQL database, and returns a value to the cell. I've successfully added the add-in to Excel. I've also successfully utilized the add-in function that returns data. For instance, I place the following function call in an Excel cell... =MyAddIn.GetValue("Q1", "SALES") ....and it returns me the Q1 sales number from the database. I save this Excel file and close it. Now, I go into the database and change the Q1 sales data to a different value. I open up the Excel file described above. My problem is that the cell with the "=MyAddIn.GetValue("Q1", "SALES")" function does not reflect the changed value. I have to physically click on the cell and hit enter for the data to refresh. My question is this: How can I get my data to refresh on the opening of the Excel file? Can I build something into the add-in that will allow me to do this? Thanks, Alex Agran |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilling Function not updating | Excel Worksheet Functions | |||
Value Function not updating | Excel Worksheet Functions | |||
how can I use the NOW() function without it updating thetime? | Excel Worksheet Functions | |||
Updating Function | Excel Programming | |||
How can I use the NOW function and keep it from auto updating? | Excel Worksheet Functions |