Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Why cells become #VALUE! when updating link file?
I've never seen this happen.
But there have been a few posts that describe this problem. One solution is to select all the cells in all the worksheets and change the = sign to an = sign. Excel will reevaluate all the formulas and should retrieve the correct value. And the only way for the updates to be made in real time is to have both workbooks open in the same instance of excel (a single user only!). If different people have the files open, then they have to save their changes and you have to refresh the links. If you share the workbooks, then you can set an interval when your workbook should go out and refresh those links--but that still depends on the other users saving their files. Mr. Low wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Why cells become #VALUE! when updating link file?
Hi Dave,
Thanks for your reply. Low -- A36B58K641 "Dave Peterson" wrote: I've never seen this happen. But there have been a few posts that describe this problem. One solution is to select all the cells in all the worksheets and change the = sign to an = sign. Excel will reevaluate all the formulas and should retrieve the correct value. And the only way for the updates to be made in real time is to have both workbooks open in the same instance of excel (a single user only!). If different people have the files open, then they have to save their changes and you have to refresh the links. If you share the workbooks, then you can set an interval when your workbook should go out and refresh those links--but that still depends on the other users saving their files. Mr. Low wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros Excel 2002 updating file names | Excel Discussion (Misc queries) | |||
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
Updating links in Excel 2002 | Excel Discussion (Misc queries) | |||
excel link updating between 2 workbooks | Setting up and Configuration of Excel | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |