Is there a way to run power query in Excel 2006?

[yabi100]

I have read that power query is not supported in Excel 2007 and earlier versions. I would like to know if there is any other way to run power query in Excel 2006? I have an assignment to run Power Query and my Excel is 2006. Any comment is highly appreciated.

 

[arthurbr]

Never heard of XL 2006

 

[yabi100]

Sorry. It is XL2007

 

[alansidman]

Power Query is only available to XL2010 and later versions. You will need to update your Excel version to allow PQ availability. Your profile indicates you are using Office 2016, Is this incorrect?

 

[yabi100]

Power Query is only available to XL2010 and later versions. You will need to update your Excel version to allow PQ availability. Your profile indicates you are using Office 2016, Is this incorrect?

Thanks. XL2016 is the Excel I use in my office. At home I use XL2007. I want PQ for my home Excel. I am thinking to use Google Sheet instead of XL2007. In the Internet, I read that I should install Power Tools in Google Sheet to be able to run PQ. But this is a little odd for me. I didn't understand why should I install an Add-In into a cloud-based software. But anyway I think I have to follow the game rules. There are many references in the Internet, Will be very happy if you guide me, where to look for fundamental info to install Power Tools in Google sheet and accomplish my task in the earliest possible time.

 

[MARK858]

I read that I should install Power Tools in Google Sheet to be able to run PQ.

The Power Tools for Google Sheets I know is an addin by Ablebits which has some extra tools to make life easier, it doesn't run Power Query

Power Tools for Google Sheets: 40+ smart tools to boost your work in spreadsheets

Merge and split data, find duplicates, work with text: all with this set of 40+ smart tools for Google Sheets.

www.ablebits.com