In order to establish a data connection to a Microsoft Access file, you need to install an ODBC driver and then configure a Data Source Name (DSN) using the Mac OS ODBC Manager app. I made a web page that explains how to do it using Office 2011. Here's the link starting with my Part 2: The general procedure is the same for Office 2016, but there are substantial differences and I haven't had a chance to make a new page for 2016. Parts 2 and 3 are the same for 2016, but you'll find my Part 3 won't work the same in 2016 because the GUI of Microsoft Query is completely missing in 2016. All you get is a little stubby window that lets you type queries.

I use Excel for Mac 2008 on my Macbook (Mac OS X 10.6.8). I recently used the file but now when I It's a very important budget-file, and ofcourse my back-up with Time Machine is from after when i last used I set the recalculation option in Excel to Manual in the Tools Menu, OPtions, Calculation tab. Turn data into insights. Enhanced by intelligence, Excel learns your patterns, organizing your data to save you time. Create spreadsheets with ease from templates or on your own, and perform calculations with modern formulas.

That means you must know the exact syntax of the SQL query you want to use. If you're OK with that, then you're all set. If you need help with individual queries, please ask a new question for each query here in the forum. For example, start a new forum question with a title something like Need Query Syntax for complex Select statement. Someone will come along and offer the correct syntax, hopefully. I am an unpaid volunteer and do not work for Microsoft.

'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. Thanks for the replies, but I am not trying to access the Access file from Excel. We have transferred the data from Access to Excel on the Mac, so far so good. What we then want to do is have the master sheet in the Excel file then create another sheet within the same file and link data back to the master sheet, so basically the Excel file links to itself. This is possible and very easy in the Windows version of Excel, but can't find a way to do it in the Mac version.

I have tried setting the configuration up in the Windows version then opening it in the Mac version, but the link doesn't work anymore. Regards, Brett. Does your method in Excel for Windows involve using the Excel Data Model? If so, you'll have to wait a little bit longer because that the Data Model feature is being ported to the Mac but isn't here just yet. I am not aware of anything in particular in Excel for Windows that you can't do with a regular worksheet in Excel for Mac. Can you explain the steps you're taking in Excel for Windows that don't result in a link on the Mac?

I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. The process you described is what I suggested on 11/23 where you create an ODBC connection.

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 list in the ODBC manager. I am an unpaid volunteer and do not work for Microsoft.

'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.

I've made a Pivot Table / Chart in Excel on Windows 10. See screenshot below. I've sent the Excel document to a person who opened it on a Mac (see photo below). When she opens the file on the Mac, there are no filtering buttons on the bottom of the chart and there are no filtering fields on the right side of the worksheet (even though you can see them on Windows). Is this a limitation of using Excel on the Mac? Or is it some setting that needs to be fixed? Something else?

Thanks for any insight.