cell reference data updation

[punna111]

Hi all,

i have given cell reference from workbook A to workbook B.
When i update something in workbook A it is automatically showing.
Here i opened 2 workbooks in one computer.
2 workbooks are in share drive

till this perfect.

but when i open workbook A in one computer, and workbook B is another computer it is not happening why ?
is there any particular reason ?

can i have a solution ? macro ? code ? to do this...

please help me....

[arlu1201]

Is the folder in the 2nd computer on share mode? How would workbookA pick up the values from workbookB unless the 2nd one is on a shared computer?

[punna111]

2nd computer folder is also in share mode.
I am opening two files from different computers, but two are in one share drive only.

[arlu1201]

Do you already have a macro in either of the files or are you updating the data using the update option in "Edit Links"?

[punna111]

First of all Thanks a lot for replying this thread. i am waiting for this from long back. if we do this lot of time is saved.

i dont have any macro to do this. i am giving just cell reference.

i need: when the work book A data updating in one computer. it should be updated in workbook B. but that workbook B is in another computer.

if any macro is there to do this? please help me.....

Regards,
PRB.

[arlu1201]

Yeah, you can have a macro that opens that 2nd file, copies the data and closes it.
Can you provide some details like sheet name, range to be copied, etc and where it has to be copied?

[punna111]

i am giving the following details

sheet name of workbook A - sheet1
Range of work book A - A2:K200
workbook A name is "tracker"
workbook B name is "dash board"
sheet name, Range of workbook B is same as workbook A

is this macro automatically refers this data?

[punna111]

hi arulu,

can you please resolve this......

Thanks,
PRB.

[arlu1201]

Will check this tomorrow for sure. Time to hit bed now.

[punna111]

hi arulu,

can you please resolve this......

Thanks,
PRB.