if any cell value changes, then display in some other area that va
 

Hi,

I have one sheet in which i have linkage of many sheets, everymorning i need
to take print of that, but most of the time, some information will not
updated. how i can know that all information is updated.


Thanks

if any cell value changes, then display in some other area that va
 

If you know where the files are (the ones that are linked), check to make
sure that they have been updated that morning (in the Explorer Window, View
-- Details, look at "Date Modified" column).

There is a more complicated way (create macros that copy data to a new sheet
and check it against the supposedly "updated" data), but this would probably
work for you.

Hope this helps, Jim

"Deepti" wrote:

Hi,

I have one sheet in which i have linkage of many sheets, everymorning i need
to take print of that, but most of the time, some information will not
updated. how i can know that all information is updated.


Thanks