Hi, A Family Member who uses Excel for Business work, came to me asking me why excel functions are not show up in formula bar when they click on the cell. all that appears is the value in the cell also appears in the function bar (like the cell was manually typed in the numbers) . they assure that the numbers are automatically generated from a custom function, however there isn't anything other than the values. so i have no idea where they could have gone.
heres what i know:
- excel workbook (xlsx format), macros are enabled
-VB add-in is applied to the workbook
- Showing/forcing all cells to show function, only has a few that display. but the ones they are concerned about just show a number like 30.8 (while force functions show 30.8898898955454343 and so on) - I can get the VB modules and all the add-in and put it up (i just have to get it all together to attach) . however the workbook has private information for business, so it has to be censored if any needed to see the workbook.