Update Readonly.

[The Tamer]

Is there a way I can update a read-only workbook to reflect any changes that may have been made in the write version?

Thanks

[Jacob Hilderbrand]

You can save the Read Only workbook with a new name. Then delete the old version and replace it with the one you just saved. You will need to make the new file Read Only as well (assuming you still want it to be Read Only).

[The Tamer]

Sorry Jake,

I don't mean saving changes made to the read-only version, I mean updating the readonly version with the changes made on the read-write version (that is open on another PC)

[Jacob Hilderbrand]

Well... Just save the write version and close and reopen the Read Only version. Or is that not an option?

[Zack Barresse]

Yes, close and re-open the Read Only version. Once it's open, it will act on it's own and be independent of it's original workbook. You could write a macro to do it for you, but it'd probably be just as fast to close/re-open it.

[The Tamer]

Cheers all. I've fixed it as well as I think I can now.

[manoj kumar]

Is it possible?
If Cell A1>B1 then result in Cell C1 will be blink or flash
Please help to find out

regards
Manoj