Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help to Control the UDF from re-calculation
Hi Excel Experts,
Ive developed an add-in function in Excel to assist peers to pull out accounting data from our database according to criteria like account group number, ledger code and accounting period. This function is basically constructed using Windows query connected to a MS Access database. It works fine when the function is not heavily used in the spreadsheet. However, in the case of building a profit/loss by month report, the matrix of 12 columns (month) x 100 A/c rows (total 1200 cells) of this add-in function could be a nightmare! It takes more than half an hour to complete the calculation on my PC (Windows XP; CPU 3.00GHz 2GB RAM). This time-consuming calculation process repeats every time the file is re-opened. To avoid this function being evaluated upon opening the file, I tried to keep the active cell value by inserting codes inside the function to bypass the time-consuming SQL portion, but the active cell value is fact empty and does not contain the visible value last returned by the function! I therefore request for expertise advice in the forum. Anyone out there wishing to help me to resolve this issue would be much appreciated. Regards, Steve C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
How to control calculation of specific cells | Excel Worksheet Functions | |||
Selecting control on userform with part of control name (set question) | Excel Programming | |||
Need to have control of the calculation to specific ranges | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |