View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.links
Magnus Flysjö Magnus Flysjö is offline
external usenet poster
 
Posts: 1
Default Links not updating automatically


When I open the document, I click Yes to the "Do you want to update
links?"
question, but the information in the linked cells is not updated.
However,
if I click on the cell, then click at the end of the link in the formula
bar
and press Return, the link updates.


We have the exact same problem, and it has started recently. The version is
Excel 2007 with all the latest updates applied.
If we open a .xlsb file with links to other files, half of the cells with
links shows zeros, and the rest show data. (pointing to the same source/link
file).
We have files that easily reproduce this error if someone wants to have a
look at it, it's defenetly something spooky in Excel after the latest
updates.

/Magnus