LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros Excel 2002 updating file names cbaliles Excel Discussion (Misc queries) 1 March 31st 09 07:36 PM
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? Mr. Low Excel Discussion (Misc queries) 2 August 29th 07 11:46 PM
Updating links in Excel 2002 Kim Excel Discussion (Misc queries) 0 August 17th 07 02:17 AM
excel link updating between 2 workbooks Steve Paul Setting up and Configuration of Excel 2 November 1st 06 12:01 AM
When updating a worksheet, how do I create a link updating the sa. Phlashh Excel Worksheet Functions 9 January 27th 05 06:05 PM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"