I am using design tables which contain various formulae. Is it ok to use 'Protect Sheet' option provided by excel to protect them? Is it safe? Anybody here with bad experiences??
Thanks in advance!!
Why you want to protect that in first place?
Either way yes you can protect the sheet and that should work fine. Though I've not tried that but I don't see any foreseen issues.
The easiest way I found to protect the designtable is by making the part itself that contains the designtable read only on windows level.
Much easier to 'unlock' I would think then by 'protect sheet'.
Reason to protect is because it's not unheard of that once in a blue moon for one reason or another SW decides to truncate a design table. It's no fun to see a part with 40 configs in a designtable being reduced to 2 configs.
Or that the values of a certain colomns become static values instead of being based on a formulae.
I completely agree with you on that Peter but what if the file gets corrupted?
I only reason I could see if that user may not want other to look as what formulas have been used (IP issues) OR not let them mess with the formulas.
My requirement is, to make only a few cells inaccessible for users. Rest of the design table should be editable.
I am also concerned with the same question. What if files get corrupted? That is why, i am looking for if anybody has the experience or history on this...
Thanks a lot!
I’ve never had a standalone Excel file corrupted by Excel but Solidworks will occasionally corrupt the embedded Excel design table. For this reason I use a standalone Excel file for all my most important and complex formulas then use links from the design table to the Excel file. This also allows the same data to be used in multiple part and assembly configurations.
The standalone .xlsx file has Always Create Backup and Autorecover turned on and also has selective cell Protection. This file is backed up incrementally and daily.
Retrieving data ...