On the Mac you use the Mac OS ODBC Manager to create the Data Source Name (DSN). Once you have established the DSN you choose it in Excel using the Data Ribbon > New Database Query > From Database > select the table from the I made a web page that explains how to do it using Office 2011.

If you are a daily user of Excel files, then you must know the varieties of application and features Microsoft Excel serve. Yes, it is one of the widely used spreadsheet program of Microsoft Suite. It is equipped with so much facilities and user-friendly features that it has literally replaced the standard worksheet program Lotus 1-2-3.

It is basically used for organizing data, phone numbers, call list details, customer details, address list, salary receipts of employees, etc. Now if so much data is stored in your computer without any password protection, it is most likely to be misused by intruders, strangers, and hackers. Thus you must password protect your Excel files in order to safeguard your data. The article here would explain you the few of those methods which would help you to password protect your excel files in few simpler steps. Method #1: Password Protect Excel Files using Save As Option This is one of the convenient and quickest methods of all to password protect your Excel files. We all have used Save As option while saving the documents, but has never noticed the exceptional feature it possesses to encrypt passwords to your file.

Open a workbook in your Microsoft Excel software which you want to password protect here. Now go to the “File” tab and click on it.

From the drop-down menu, select “Save As” option to initiate the process of password encryption. Click “Browse” from the next context menu to select the exact Excel file for the password protection.

Now beneath the “Save” button, click on “Tools” option. From the sub-menu that turns up, select the “General Options” option. A new window will appear in which you have to enter your password in an empty box and click “Ok”. Re-enter the password for confirmation and click “Ok” again.

Now; enter a file name and save the file with the password encryption. And there you go! So now if you open the excel file, you will be prompted to enter the password which you had set just earlier to get access to the protected file. Method #2: Password Protect Your Excel File with Protect Workbook Feature In this section of method, we would employ the use of Protect Workbook Feature to encrypt the excel file. It is equally applicable and reliable like the previous method to password protect your excel file but you need to have basic knowledge of using Microsoft Excel software or else you might find it a bit difficult to follow up the procedure. The guideline for the method is elaborated in few simpler steps: Step 1.

Click on “File” button from the top of the screen. Step 2 Select “Info” from the sub-menu and then click on “Protect Workbook” option. From the drop-down menu of “Protect Workbook”, choose “Encrypt with Password” option. A new window will turn up with a blank dialog box for password entry. Enter your password and then click “Ok” to proceed.

Kindle for mac app will not register. Method 2: Read Kindle Books on Mac with iBooks EPUB is one of the most common ebook formats (the other one is PDF) and Most e-readers support including Mac computer. Though there are many ePub readers we can use on the mac, but here I strongly recommend you use iBooks app to read ePub books as it is definitely the best reading app on the mac.

Re-enter your password to confirm the password and click “Ok”. And it’s all done! Now if you open the protected excel file, you will be asked to enter the password which you had just created. In case you forget the password then there is no way out to find out the forgotten password. Conclusion: Excel files are very important to store a huge amount of data, and in fact in today’s generation most of the data lists and official information are exchanged as Excel Files or with.xlsx extension.

And with the advancement of this incredible spreadsheet program, risks and theft possibilities have equally attained their pinnacle to cause your trouble. Thus besides using the excel files on a daily basis, you must keep a track of whether they are password protected or not. In case the files are not encrypt with passwords, use the methods explained above to immediately password protect the excel files.