View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Twishlist Twishlist is offline
external usenet poster
 
Posts: 54
Default Control + Grave accent doesn't show formula result, format is gene

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.

"Twishlist" wrote:

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?