I am using XLConnect to copy monthly data to a template. The template has vlookups and I can get the new data to the new template file no problem. THe problem is in excel the new template now with the new data the vlookups don't recognize the data until I manually click each cell and the formula bar then it recognizes the data.
I have tried changing the formula to automatic but that still doesn't work. Anyone seen this problem?
question from:
https://stackoverflow.com/questions/66068350/xlconnect-disabling-vlookup 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…