Formula bar showing Names not the actual formula

[tanvirabid3]

My formula bar is showing names that have been saved in the name manager. When I delete the names all the formulas show errors. Is there a way that the formula bar would show the actual formula instead of the Name. I inherited this worksheet from someone else. Any assistance. Thanks

 

[Joe4]

Welcome to the Board!

I have never heard of such a thing happening. Are you sure that you are looking at the "Formula Bar" and not the "Name Box"?
They usually both appear in the formula bar.

If that is not the case, can you post some screen prints of what you are seeing?

 

[Alex Blakenburg]

My formula bar is showing names that have been saved in the name manager. When I delete the names all the formulas show errors. Is there a way that the formula bar would show the actual formula instead of the Name. I inherited this worksheet from someone else. Any assistance. Thanks

Not if the put the formula is in the refers to field of a Name. You would have to manually copy the formula from the refers to box into the formula bar of the cell.

@Joe4, I posted on it here,
Post in thread 'How is calculation made without seeing the formula'
How is calculation made without seeing the formula

 

[jasonb75]

When I delete the names all the formulas show errors.

If the name no longer exists then the formula can not see what it refers to so you will get #REF errors. If you want to delete the named ranges then you need to edit the formulas to use normal ranges first. Hopefully you have a backup of the file from before you deleted the names, otherwise you will not be able to recover them.

 

[Joe4]

Not if the put the formula is in the refers to field of a Name. You would have to manually copy the formula from the refers to box into the formula bar of the cell.

@Joe4, I posted on it here,
Post in thread 'How is calculation made without seeing the formula'
How is calculation made without seeing the formula

Interesting. I had not seen that before.
Thanks for the information.