thanks p45cal for quick reply. it seems after i fixed them its working again. i dont know how it gets #VALUE! errors.

those #VALUE! comes from an formula mentioned in this thread. if click those cell without corresponding files opened. this error occurs. after open this files, errors fix themself automatically.


Also row range needs to be increased to 200