View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.links
Lance Lance is offline
external usenet poster
 
Posts: 39
Default A link between two workbooks doesn't keep the value, shows #va

I guess my big question here is why did this appear to work in Excel 2003,
but not now in Excel 2007? It used to be that users would elect not to
update the links and then in the spreadsheet they received via e-mail, it
would have the data still contained within the spreadsheet--though it was
stale, at least it was there.

Now in Outlook 2007, it appears as if the data is no longer available unless
it can update the links OR unless I save the file locally, open excel by
itself, turn calculation of formulas to manual, then open the spreadsheet
from within Excel 2007. Any thoughts on this and how to get it to function
as it did in Excel 2003?

Much appreciated!
Lance