When exporting a report to Excel, I am unable to edit any cell without data already populated unless I "Unprotect" the sheet. This is a relatively recent addition (granted we've been using Master Builder since version 3.0). I heard the reason was because Excel doesn't "trust" the source of the file.
1) If that is the case, why can I edit any cell with data without "unprotecting"
2) I haven't run into this with other programs. Is there some Microsoft certification that can be established to allow trust? Its just an extra step that benefits no one.
by: Joel D. | over a year ago | Accounting Reports
Comments
Yes I agree
That is rather annoying and seems like it should be a simple fix to implement.