Janet Erbach
jerbach at gmail.com
Tue Nov 30 09:12:10 CST 2010
Susan - Are the formulas the same for each row? Could you put one set of formulas on a separate page (do they call that a 'workbook' now?) within your spreadsheet? Or even place the formulas in an external worksheet? You could data protect those cells and then use absolute referencing in your formulas pointing to the new page/spreadsheet. (You might even be able name each formula and use the names in place of cell addresses - I haven't used names a whole lot, so I can't say whether it's worth the effort or not.) I used to have a very complex sales forecast spreadsheet that was built entirely on links to an external spreadsheet - it worked great. Janet Erbach On Mon, Nov 29, 2010 at 5:47 PM, Susan Harkins <ssharkins at gmail.com> wrote: > > > Is there anyway to keep users from changing formulas, etc. in specific > cells without turning on protection? > > I'll tell you what I'm doing, because maybe there's a better way. Users can > enter new records, as many as they like -- but the cells at the far right > have formulas. I don't want them to keep entering, right over the formulas. > However, if I unlock the data entry cells and turn on protection, they can't > enter as many records as they like, unless of course, I unlock a huge range > of cells -- down to row 65535. Is that the only recourse? > > I just noticed something else interesting. I have the extend formulas and > formats option selected and it works fine, except in the last data entry > column. I can't get Excel to copy a border format to the new record. > Curious. > > Susan H. > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >