charlesa920
12-15-2007, 10:36 AM
I'm sorry but I didn't find anything by searching. Probably becuse I don't know what to search for...
I have two workbooks... radio.xls and activeIPinRadio.xls
activeIPinRadio.xls has one sheet with one column containing data. Each cell in this colunm is a formula linked a different cell in radio.xls.
I run a third batch file using activeIpinradio.xls as my source.
It is important that the linked cells be updated in activeIPinRadio.xls anytime and value in columnB of radio.xls is updated... seeing it is Excel and changes can be disregarded when saving (or crashing) should I force a save?
Surely this has been addressed but unfortunatley I am not able to find it...plz help
Thanks
Charles
I have two workbooks... radio.xls and activeIPinRadio.xls
activeIPinRadio.xls has one sheet with one column containing data. Each cell in this colunm is a formula linked a different cell in radio.xls.
I run a third batch file using activeIpinradio.xls as my source.
It is important that the linked cells be updated in activeIPinRadio.xls anytime and value in columnB of radio.xls is updated... seeing it is Excel and changes can be disregarded when saving (or crashing) should I force a save?
Surely this has been addressed but unfortunatley I am not able to find it...plz help
Thanks
Charles