Query in Mac Excel 2011

nealt

Registered
The data ribbon does not show queries. I found a procedure for combining spreadsheets for Excel PC that requires Queries. Is it not possible in Excel 2011?
Attached is what you get on a PC.201807208_1007-CapturFiles.png
 

nealt

Registered
I noyoce that there is a query app in the Office folder. I don't know how to incorporate it into Excel.
 

DeltaMac

Tech
You can find out how to use that Query app by launching Query, and opening the help info file from the Help menu.
You will then see that, first, you need to install a compatible ODBC driver, which is not included with Excel for Mac 2011.
The Query help gives you several links to companies that offer an ODBC driver. When you have that installed, the help information will then walk you through how to setup and use a query.
 

nealt

Registered
You can find out how to use that Query app by launching Query, and opening the help info file from the Help menu.
You will then see that, first, you need to install a compatible ODBC driver, which is not included with Excel for Mac 2011.
The Query help gives you several links to companies that offer an ODBC driver. When you have that installed, the help information will then walk you through how to setup and use a query.
 

nealt

Registered
I found the help file and do not know which of the many drivers to use. Some or all are not free. All I want to do is use query to combine multiple Excel files into one.
Apparently the drivers are provided or not required for the PC version of Excel.
 

DeltaMac

Tech
There must be other methods to combine multiple Excel files, that don't need to use Query?
I notice there is a "Merge Workbooks" under the Tools menu, and "consolidate" under the data tab. Maybe one or both of those will help you along to what you need to do...

(Wish I knew more about Excel :confused: )
 

nealt

Registered
I believe that merge and consolidate require all workbooks to be opened. That is not the case here.
Lets say I have 100 spreadsheet files in a folder. I want to consolidate-merge them onto a master spreadsheet that is opened.
Any ideas?
 

DeltaMac

Tech
I think that you have a good case for using Excel for Windows - or update your Office suite to 2016
(I suspect that is because Office for Mac does not include the Access app, which seems to be related directly to Query (I think! I still wish I knew more about Excel)

Found this, which might help you, or at least point you in a different direction: https://answers.microsoft.com/en-us/office/forum/office_2007-excel/how-to-combine-multiple-sheets-into-one-sheet-of/3e3432e0-ec7a-44aa-8cc4-3e8992b50235?tab=AllReplies#tabs
 

nealt

Registered
I rarely use Microsoft office. I prefer LibreOffice. However I have not figured out how to use its query. My daughter has MS Office on her PC and it has Query. I was trying to duplicate her procedure for combining spreadsheet files, just for fun, . I don't want to spend $120 for a program I would rarely use.
 

Lovely K

Registered
Hi, multiple sheets can be easily merge into one by using Power Query. Check if it is properly activated because it is a separate tool that needs to be downloaded from Excel. Also, there is also a tool called as Power Pivot, which helps to apply Pivot on multiple sheets together. You can also try using this one.
 

DeltaMac

Tech
Hi, multiple sheets can be easily merge into one by using Power Query. Check if it is properly activated because it is a separate tool that needs to be downloaded from Excel. Also, there is also a tool called as Power Pivot, which helps to apply Pivot on multiple sheets together. You can also try using this one.
That's a bit of misinformation. Power Query (and Power Pivot) are only on Windows Office, and not supported on Office for Mac, in any version.
Looks like there are a number of threads at Microsoft support, asking for those to be added for the Mac versions, but so far, nothing.
 
Top