Bulk data manager writing "function disabled on excel sheet instead of process histroy value in particular cells
IMHO: There has been a cat-and-mouse-game between ABB and Microsoft when it comes to the different 800xA plugins to Excel; Microsoft patches a security problem which makes trouble for BDM, DataDirect, etc.. ABB implement a workaround which is released in a subsequent rollup. Then Microsoft makes a new correction... repeat, repeat, repeat...
800xA Base S-FP 5.1.4-2 is "5.1 RevE" and according to the Third Party Software Versions (3BUA000500) document on ABB Library you can use Excel 2007, Excel 2010, Excel 2010 SP1, Excel 2010 SP2 or Excel 2013.
Please note that you must use the 32-bit version of Excel.
Without knowing for sure, the version of BDM you are using may be cut to work with the latest version of Excel.
I suggest that you try reinstalling BDM or update to a more recent version of Excel.
FYI: as of 800xA v6.1, BDM comes as a standalone app with no dependency to Excel.
In any case, don't hesitate to file a support case with your regional ABB support center.