How to get the Query ribbon in Excel 2013

N

NewUser2

Board Regular
Joined
Jan 27, 2015
Messages
54
I use Excel 365, created a query in it and sent the file to a peer with Excel 2013. When they click in the Query data of the file, the Query ribbon doesn't appear. I am assuming (from searching) that this functionality isn't available in 2013. Does anyone know a simple workaround that doesn't involve starting from scratch by creating formulas? Can they somehow turn on queries in the 2013 version?

Simple solution! Have them upgrade to MS 365. Unfortunately that's also not on the table, his work wont support it.

Thanks!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

Anigito
  • Question
Get Webpage Title Text by URL Generated in MS Excel
Replies
1
Views
426
Anigito
Anigito
N
  • Solved
Loop to get emails from Outlook 365 has broken, and I cant work out why !
Replies
3
Views
502
netrixuser
N
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
555
ahaye
A
C
  • Solved
Macros taking considerably longer on Microsoft Excel 2016 (vs 2013) in specific PC
2 3
Replies
22
Views
5K
Crones8
C
E
  • Question
Some Cells After MS Query Table Refreshed Have to Be Clicked before Formatting Works
Replies
2
Views
833
elwayfan446
E

Forum statistics

Threads
1,214,932
Messages
6,122,323
Members
449,077
Latest member
jmsotelo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top