Version Verification for Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2851765%22%20slang%3D%22en-US%22%3EVersion%20Verification%20for%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2851765%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3EI%20have%20a%20built%20out%20quote%20tool%20in%20excel%20that%20is%20used%20by%20salesman%20for%20pricing.%20An%20issue%20we%20are%20encountering%20is%20that%20we%20have%20salesman%20using%20out%20of%20date%20quote%20tools.%20Whenever%20we%20make%20changes%20we%20send%20out%20a%20fresh%20excel%20file%20with%20the%20updated%20changes.%20Is%20there%20a%20good%20solution%20to%20prevent%20users%20from%20using%20older%20versions%20of%20the%20file%20and%20only%20allow%20them%20access%20to%20the%20newest%20version.%20I%20have%20tried%20looking%20at%20ways%20to%20do%20this%20but%20every%20way%20that%20I%20found%20was%20fairly%20advanced%20and%20not%20feasible%20for%20my%20end%20users%20who%20know%20nothing%20about%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2851765%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Greetings,

I have a built out quote tool in excel that is used by salesman for pricing. An issue we are encountering is that we have salesman using out of date quote tools. Whenever we make changes we send out a fresh excel file with the updated changes. Is there a good solution to prevent users from using older versions of the file and only allow them access to the newest version. I have tried looking at ways to do this but every way that I found was fairly advanced and not feasible for my end users who know nothing about excel.

 

1 Reply

@BMK-520 I'm no expert on the matter on how to prevent users from using the wrong files, but I have quite some experience in dealing with sales people when it comes to calculating their commissions. Sales reps are driven by earning commissions. Add a simple business rule stating that commission will only be earned on orders that were based on the valid calculation tool.