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.