I would like to reduce the amount of clicks for an end user to make changes to documents from a SharePoint document library. Ideal scenario: 1st click - Opens Excel spreadsheet from Doc Library via a Web browser 2nd click - make a change to the files meta-data using a drop down box via the Document Panel Library 3rd click - close down the document which then auto-saves the document Currently I'm closing down the document and getting prompted to save the file which means 4 clicks. Any help would be appreciated please.

HI, Don't try to reduce the amount of clicks here. It is only about one click more for saving the document. By the way there is no solution for this.Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

Just my opinion of course, but this works and is straightforward and understandable to your users. So why don't you spend your development time on something of real use.2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc. 2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow Both lists also include books in French; German; Spanish with even more languages in the 2007 list.

OK that's not the point, I'm trying to reduce clicks so Operators who are processing 500+ timesheets a week are not having to click so much to reduce time and strain on them.

OK that's not the point, I'm trying to reduce clicks so Operators who are processing 500+ timesheets a week are not having to click so much to reduce time and strain on them.

Not very constructive response but thank you.

Not very constructive response but thank you.

You might want to consider some type of solution to help your users out. 500+ spreadsheet updates is a lot. I'm sure there's a way that can be automated and reduce the frustration level of your user base. If your speadsheet is Excel 2007+, you can use .NET to effortlessly read and write changes to the spreadhseet. You could go even as far as processing the spreadsheet after its uploaded to the document library or received by email. Lots of possibilities.Brian Bedard, MCTS - pioneeringsharepoint.blogspot.com - Twitter:@tigertoy

You might want to consider some type of solution to help your users out. 500+ spreadsheet updates is a lot. I'm sure there's a way that can be automated and reduce the frustration level of your user base. If your speadsheet is Excel 2007+, you can use .NET to effortlessly read and write changes to the spreadhseet. You could go even as far as processing the spreadsheet after its uploaded to the document library or received by email. Lots of possibilities.Brian Bedard, MCTS - pioneeringsharepoint.blogspot.com - Twitter:@tigertoy