Forum Discussion
Excel worksheet protected but can't use text to column function
HI I have a worksheet that several people use that I need to protect. There are formulas and a pivot table. I have been able to lock what I need and am able to refresh the pivot table but I can n...
maybe just use formulas to 'convert' the data into helper columns and then point all the formula to those helper columns. If you can share examples (no private/confidential information) then we could help with some suggested formulas.