Can you protect remote data from being accessed from unauthorized use?

Yes, refer to the following Security video on how to setup user security. With the Excel Workbook use the OAS Excel Wizard with the Security option to add a security login function.  This is shown in Step 12 of the Excel – Getting Started section.

Security Setup

How to setup security for Open Automation Software in the service and in client applications.