The SharePoint "system" isn't sophisticated enough to update content within a specific document. The system is designed more for entire item/document handling. (The postman delivers the mail, but he doesn't open and react to it.)
BUT, there's always VBA. In VBA, you can open and edit documents with great ease! Cure Baldness, end hunger, etc. The difficult part is triggering the code at the appropriate time, but trial and error will help you determine it.
With that, you're probably thinking that you have to add the code to every spreadsheet, but I vaguely remember that there is the ability to make a global template that all other documents can share. You should be able to put the code in there,
and make it accessible to all other documents.
Steve Clark, MCTS | Twin-Soft.com
Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.)
Be sure to click one of them there forum buttons that artificially inflates my narcissitic ego... I mean gives me points.
