Forum Discussion
Issue in showing formulas/values
The problem that I face is when I download excel book from Google Drive and enable editing it, it shows #NAME? in all formulas instead of values. Surprisingly, before pressing "ENABLE EDITING" it sho...
It would help if you showed us the formulas or attached a copy of the workbook.
Sure, it's attached. Basically, the problem is in source sheet "Label" from where the value goes to the earlier screenshots. If F2 & enter is pressed and then only the values shows in these cells. For example, I have done F2 & enter in cell B4, C4, C5.
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- Hi,
It is not solving at my end. Please guide me further.
