Lists Dependent on another List Hangs Excel

[mytouchsr]

I have a invoice that uses a List in one cell and is dependent upon list in another cell. After about 8 or so selections the memory jumps from about 27mb to 376mb and excel hangs. The file is only 53kb so I don't think it is a file size issue, I maybe trying to do to much with the lists. I have tried on multiple computers and have the same issue. Is there a more streamlined way to perform this that does not kill excel?

I am attaching the file for viewing. Any help is appreciated.

Invoice-template.xlsm

[pareshj]

Hi mytouchsr,

Performance issue is due to recalculation of categories and product for every selection, keep a static list of category and their respective product to avoid recalculation for every selection.

[mytouchsr]

Wow, that did it!!!!! Thanks a bunch