Hi, I am using POI to populate a data sheet in a template. Another sheet in the workbook has references to data in this data sheet through VLOOKUP formula. Now if I populate data sheet cells using poi then the formulas on the other sheet do not read those values. The formula need to be evaluated manually by pressing F2 and then the values show up. Please preovide me guidance on this. The formulas on the other sheet should reevaluate since the cells the formulae are referencing are changed.
- Minal.
