Thread: #VALUE! in cells when I open spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default #VALUE! in cells when I open spreadsheet
Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Tim Chapman wrote:

I have a spreadsheet with links to other excel files. (All excel 2003). When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to. Is there any to fix this so that the
updates work without opening the other spreadsheets.

Thank you advance.

Tim

--

Dave Peterson
Reply With QuoteReply With Quote