Excelguru Help Site - Excel

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (9)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (12)

Excel - Power Query (3)

Excel - PowerPivot (7)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (49)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (1)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

Power BI (3)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (10)

Word - VBA Programming (8)

Excel - Power Query
Installing Power Query and Power BI Desktop

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

Published on 2018-07-10 01:20 AM

Installing Power Query
The Power Query add-on is installed by default in Excel 2016 and can be found in the Get & Transform section of the Data tab. However, for Excel 2010 and 2013, the add-on needs to be downloaded and installed. You can download the most recent version from the Microsoft site.

There are three things you should know about this download package:

It takes admin rights to install.
You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match your
...

Read More
Legacy Installers for Power Query and Power BI Desktop

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

Published on 2017-08-24 08:45 PM

Legacy Installers for Power Query and Power BI Desktop
Let's be honest, one of the incredibly cool things about Power Query and Power BI Desktop is that they are updated monthly. We always get new features and bug fixes, but there is a potential downside ...

Read More
Power Query Connectors

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

Published on 2017-08-23 08:51 PM

Data Connectors for Power Query in Excel
One of the things that makes Power Query so powerful is able to connect to almost any type of data source. So how come you find yourself asking, "Why is this connector not available to me?" Well, it very likely has ...

Read More

Recent Forum Posts
Private sub to refresh pivotfields

Is there a way to combine private sub with refreshing pivot fields?

Want to keep PivotFields("ABC") to always be selected as "True"....
thousand Today, 05:29 AM

Keep formatted shape to use in other workbooks

Record yourself a macro of you adding the shape and making modifications to it. Make sure you store it in the Personal Macro Workbook, you can alter the...
p45cal Today, 01:01 AM
Timestamp data with missing time

Try the button in the attached which runs this code:

Code:

Sub blah() lr = Cells(Rows.Count, "A").End(xlUp).Row For rw = lr To 3 Step -1

...
p45cal Today, 12:10 AM
The Web Query Table data in excel not the same as displayed online at the website.

I cannot see any difference. You are the one asking for help: all I have asked is that you provide a version with a few specific anomalies highlighted...
AliGW Yesterday, 04:15 PM

The Web Query Table data in excel not the same as displayed online at the website.

Just pick any one row in my 50 entries/page and compare to your attached file (same row) and you see they are not the same. This only happens in my 50...
guanstan Yesterday, 03:29 PM

Knowledge Base Articles By Category

Excel - Power Query

Recent Forum Posts