Forum Discussion
Issue in showing formulas/values
It's a weird problem, but you can solve it as follows:
- Press Alt+F11 to activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type or copy/paste the line shown below into the Immediate window.
- With the insertion point anywhere in that line, press Enter.
- Close the Visual Basic Editor.
- Adjust the column widths.
ActiveSheet.UsedRange.Formula = ActiveSheet.UsedRange.Formula
It is not solving at my end. Please guide me further.
Dharmendra_Bharwad To add to the collection of answers. I opened your file in Excel MS365. It opens immediately (i.e. without the need to enable editing), showing the NAME errors for all cells except the ones you touched. It looks like this.
All the cells with errors have the @sign preceding the IFNA function. Used Find & Replace to remove all of them. In total, 1361 ampersands where found and removed.
Then it looks like this:
No more errors.
Attaching your sample file, without errors (for me at least).
Dharmendra_Bharwad.... You can avoid the "protected view" warning and need to click Enable Editing by changing the file properties in Windows. In Win7 (my version), I do the following:
1. Save the file to local disk.
2. Right-click the file icon. Note: The file must not be open at the time.
3. Click Properties, then click Security: Unblock.
4. Optionally, click Apply.
5. Click OK.
Again, in my version of Excel, that does __not__ eliminate the #NAME error. It just eliminates the Enable Editing prompt.
It works for me, so I have no further ideas.
