On Tue, Feb 22, 2011 at 8:04 AM, Arjang Assadi <[email protected]>wrote:
> On 21 February 2011 18:08, Andrew McGrath > <[email protected]> wrote: > > Using xlsgen to manage situation very similar to yours. Has worked very > well > > on a variety of projects. > > > > Website is at http://xlsgen.arstdesign.com/ > > > > Andrew > > Hi Andrew, > > How did you manage the data validation? There is pretty much no way of > enforcing business rules on any data being entered into excel. Doing > data validation and integrity checking after receiving it is a waking > nighmare. > > Is/Are there recomended practices of having some control over the data in > Excel? > > Don't do it in excel, but in a DB, then point excel at that? -- Meski "Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough" - Adam Hills
