I export the data into sheet1 call "POB" using my excel template. All exported data are showing correctly in "POB" sheet.
But in sheet2 I used formula =PROPER(POB!B3) at cell A1 of Sheet 2 but nothing is showing.
If I open the template manually and enter the data in cell B3 of Sheet1, it is working.
Please let me know why all of my formula are gone.