I cannot fix my problem yet. It is something like what is explained here:
http://exceltips.vitalnews.com/Pages/T0732_Macros_in_Template_Files.html.
but when I follow the intructions I cannot fix my problem. I changed all the formula to the name of the excel file and macro name and save my file but again when I open the wrong path will come infront of the formula. Is there any way I can send my file to any one of you? I cannot attach here as it is big.



Thanks