Protect an Excel SpreadSheet and allow access to an external data source
Posted on 2014-04-03
Custom reports from an Access database tables are a great solution for quickly forming the results in a way that can be sorted, filtered and even creating pivot reports. We're getting a sweet tooth for this technique and it's going well.
But, the SpreadSheet can inadvertently be changed or otherwise mangled and then saved.
I know the deal with protecting Excel, etc. but this breaks the data refresh-ability. I'm no VBA jockey and can handle macro's, etc. but not proficient or practiced.
Is there a GUI kind of way to allow the SpreadSheet to open and refresh and read the data and allow users to sort, filter, etc., but otherwise protect the SpreadSheet (especially the formulas)?