View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default Excel 2002: Why cells become #VALUE! when updating link file?

Hi,

I have a file that gets data from the other files

When I open that file and click updating link or not clicking the same ,
all the link cells becomes #VALUE!,

May I know what does this means and how to overcome this ?

For the cells to be updated on real time basis when the data of the other
files are updated What must I do ?

Thanks

Low

--
A36B58K641