PDA

View Full Version : [SOLVED] Update Readonly.



The Tamer
11-05-2004, 03:15 AM
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
11-05-2004, 04:48 AM
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
11-05-2004, 05:39 AM
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
11-05-2004, 06:54 AM
Well... Just save the write version and close and reopen the Read Only version. Or is that not an option?

Zack Barresse
11-05-2004, 09:34 AM
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
11-05-2004, 10:06 AM
Cheers all. I've fixed it as well as I think I can now.

manoj kumar
05-22-2009, 11:25 PM
Is it possible?
If Cell A1>B1 then result in Cell C1 will be blink or flash
Please help to find out

regards
Manoj