 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Getting back the same document we sent.
Using Excel 2003... Monthly, we send excel spread sheets to clients who edit them and then send them back. Unfortunately, buy the time they send them back, they have usually renamed them. We are always worried that that are sending back an older excel spread sheet that they have worked on. It there any way to confirm the excel spread sheet we are getting back is the one se sent them (i.e. the most recent one?). It would have to be something they cannot edit, so merely adding a date cell or something like that would not work (unless you could lock only that cell without protecting the entire spread sheet, which I don't see how to do). Any ideas? Thanks Bob Hi You could write a version number and date on another sheet, then Hide the sheet. Probably unlikely the client would Unhide the sheet and change the data then Hide again.  SignatureRegards Roger Govier > Using Excel 2003... > [quoted text clipped - 13 lines] > Thanks > Bob Perhaps a formula in a cell that creates a hash code of some unique cell contents of the particular sheet. If they over write that the change should be apparent. > Using Excel 2003... > [quoted text clipped - 12 lines] > Thanks > Bob Bob: You might want to look in VBA Help and google the excel.programming newsgroup for CustomDocumentProperties. You can add a value into the Properties of your workbook that can be checked - if it's not there, you've got a different workbook instead of an updated workbook. Ed > Using Excel 2003... > [quoted text clipped - 12 lines] > Thanks > Bob > It would have to be > > something they cannot edit, so merely adding a date cell or something like > > that would not work (unless you could lock only that cell without protecting > > the entire spread sheet, which I don't see how to do). > > > > Any ideas? Just a thought, doesn't Acrobat create PDF's where some parts are editable, and some fields protected and unalterable?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.