Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Area chart display ENDS before data ? | Charts and Charting in Excel | |||
How can I display my table in chart area? | Charts and Charting in Excel | |||
how to display the referral area of a name | Excel Discussion (Misc queries) | |||
Combination chart - area and column - order display? | Charts and Charting in Excel | |||
Display Text in the Data Area of a Pivot Table | Excel Discussion (Misc queries) |