EXCEL 2010 : Will Auto Calculate Formula , work even if the workbook is not opened ??
I am using forumales like "=today()" in excel cells. Have set on the option (AutoCalculate formulae)
So it is auto calculating every day if I open the workbook. I am fetching that cell value throuh QTP for test data......
Issue : I have to open the excel workbook manually every day , just to make my test data auto calculated every day.....QTP is accessing the test data file but , the formula is not auto calculating.....
Is there any option to auto calculate the formulae , even if the workbook is not opened ??????????