Control + Grave accent doesn't show formula result, format is gene

[Twishlist]

Have checked to ensure cell is formatted as General, not text, but still
Control + Shift + Grave Accent doesn't toggle - I'm still viewing formula
rather than result.
Control + Grave accent (without shift) makes all the columns in the
worksheet jump to a new width (wider). Any insight?

 

[Twishlist]

I've just resolved this...I have to save the new workbook before I make the
link, otherwise the value won't display, just the path. If link is made
before new workbook is saved, it won't display result unless I redo the link,
not matter how much grave accenting goes on.