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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

M
  • Solved
How to move custom VBA/ribbons
2
Replies
12
Views
554
missingsc
M
J
  • Question Question
How to get top 10 recently modified files from the file explorer on the Excel ribbon as 10 Macros(one Macro for each of the 10 Files)
Replies
2
Views
152
Julia Kurakula
J
P
  • Locked
  • Question Question
Mail Merge - Using Excel & Word, how to select specific criteria ?
Replies
1
Views
188
Fluff
Fluff
Anigito
  • Question Question
Get Webpage Title Text by URL Generated in MS Excel
Replies
1
Views
1K
Anigito
Anigito
N
  • Solved
Loop to get emails from Outlook 365 has broken, and I cant work out why !
Replies
3
Views
785
netrixuser
N

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

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