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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Twishlist - 10 Jan 2008 00:17 GMT

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?

Reply to this Message

Twishlist - 10 Jan 2008 00:27 GMT

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.

> 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?

Reply to this Message