Windows 10: The excel new web query yellow arrow only on advertisements

PichuWong · Dec 29, 2021

I open excel 2010 and go to get external web data and the yellow arrow selectors are all on the advertisements instead of the tables. How to fix this. Windows 8 doesn't not have this issue how to fix this?

:)

Brink · Dec 29, 2021

What is New in Excel for the web (December 2021)

On Internet Day – October 29 – we shared with you how Excel for the web has continued to evolve from a companion app used for consumption to a full-featured modern spreadsheet experience. This incredible journey is made possible by continuing listening to you, addressing your feedback, and evolving to meet your needs.

Today, we bring you a set of new features and improvements making Excel for the web a more effective app for your daily work.

Searchable data validation list

Queries pane

Text in shapes

Paste option floaty

Sheet direction switcher

Searchable data validation list

Selecting an item from a drop-down list is now simpler especially when the list is long. Search within the list by typing any letter that is part of the item you’re looking for and Excel for the web will help auto-complete the search for you. Blank values are hidden from the drop-down list and duplicate values are removed.

Searchable data validation list

Queries pane

The full Power Query experience that you know and love is rolling out to Excel for the web. Coming first is the Queries pane – with the familiar user experience of the Queries & Connections pane in Excel desktop. With this Queries pane, you can view all the queries in the workbook in Excel for the web.

Queries pane

Text in shapes

Using shapes to add design and context to your data and analysis? You can now add or edit text in shapes with ease. Select a shape and start typing to add or edit text in the shape – alternatively, double click on the shape or right click and select Edit text.

Add or edit text in shapes

What’s more? You can now add a text box by selecting the Insert ribbon tab > Shapes > Text box and start typing to add text.

Add text box

Adding and edit text in shapes wouldn’t be complete without the ability to format text. You can change font style, size and color using the text formatting options on the Home ribbon tab or via the quick option floaty when you select and right click on the text.

Format text in shapes

Paste option floaty

Access all the Paste options right where you’re pasting content – you can also select the option after you paste.

Paste option floaty

Flip sheet direction

For users preferring right-to-left (RTL) experience, you can now flip a spreadsheet to RTL at the click of a button – on the Page Layout ribbon tab. Previously available only in Excel desktop, switching to RTL – and back – is now also available in Excel for the web.

Flip sheet direction

These are just some of the latest improvements, many more are coming soon!

Your feedback helps shape the future of Excel for the web. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.

Want to know more about Excel for the web? See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

Thank you!
Click to expand...

Source: https://techcommunity.microsoft.com/...1/ba-p/3035350

Brink · Dec 29, 2021

April 2017 updates for Get & Transform in Excel 2016 and Power Query

Excel 2016 includes a powerful set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.Today, we are pleased to announce five new data transformation and connectivity features that have been requested by many customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved data connectivity and transformation features:

Support for the same file extensions in Text and CSV connectors.

ODBC and OLE DB connectors—support for Select Related Tables.

Enhanced Folder connector—support for “Combine” from the Data Preview dialog.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor.

New Insert Step After option in Steps pane inside Query Editor.

Support for the same file extensions in Text and CSV connectors

With this update, we revised the list of supported file extensions in From Text and From CSV connectors. Now, you can browse and select any text (*.txt), comma-separated value (*.csv) or formatted text space delimited (*.prn) file as the first step of the import flow for both connectors. Alternatively, you can switch to the All files (*.*) filter option and select to import data from any other unlisted file.

ODBC and OLE DB connectors—support for Select Related Tables

When using the ODBC and OLE DB connectors, we enabled the Select Related Tables button in the Navigator dialog. This option—already available for other relational data sources—allows users to easily select tables that are directly related to the set of already selected tables in the Navigator dialog.

Enhanced Folder connector—support for Combine Binaries from the Data Preview dialog

In the January 2017 update, we shipped a set of enhancements to the Combine Binaries experience. You can learn more about those enhancements in this article.

This month, we made it easier for customers to access the Combine Binaries feature by allowing them to combine multiple files directly from the folder Data Preview dialog within the Get Data flow, without having to go into the Query Editor.

Note that exposed multiple options (Combine and Combine & Load) allow customers to further refine their data before loading it into the worksheet or Data Model.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor

In the Query Editor, it is possible to see and modify column types by using the Column Type drop-down menu in the preview area.

With this release, we added the Change Type Using Locale option to this drop-down menu (previously available by right-clicking the column header and then selecting Change Type > Using Locale). This option allows you to specify the desired column type and locale to use for the conversion, which affects how text values are recognized and converted to other data types, such as dates, numbers, etc.

New Insert Step After option in the Steps pane inside Query Editor

With this update, we added a new context menu option in the Query Editor window to easily insert new steps in existing queries. The Insert Step After option lets users insert a new custom step right after the currently selected step, which can be the final step or any previous step within the query.

Learn more

Learn more about what’s new in Excel 2016.

Join our Excel community on Facebook and Twitter, and collaborate with others on Get & Transform Data at our new Tech Community forum.

Send us your ideas for other improvements on our Excel UserVoice page.

—The Excel team
Click to expand...

Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs

Brink · Dec 29, 2021

April 2017 updates for Get & Transform in Excel 2016 and Power Query

Excel 2016 includes a powerful set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.Today, we are pleased to announce five new data transformation and connectivity features that have been requested by many customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved data connectivity and transformation features:

Support for the same file extensions in Text and CSV connectors.

ODBC and OLE DB connectors—support for Select Related Tables.

Enhanced Folder connector—support for “Combine” from the Data Preview dialog.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor.

New Insert Step After option in Steps pane inside Query Editor.

Support for the same file extensions in Text and CSV connectors

With this update, we revised the list of supported file extensions in From Text and From CSV connectors. Now, you can browse and select any text (*.txt), comma-separated value (*.csv) or formatted text space delimited (*.prn) file as the first step of the import flow for both connectors. Alternatively, you can switch to the All files (*.*) filter option and select to import data from any other unlisted file.

ODBC and OLE DB connectors—support for Select Related Tables

When using the ODBC and OLE DB connectors, we enabled the Select Related Tables button in the Navigator dialog. This option—already available for other relational data sources—allows users to easily select tables that are directly related to the set of already selected tables in the Navigator dialog.

Enhanced Folder connector—support for Combine Binaries from the Data Preview dialog

In the January 2017 update, we shipped a set of enhancements to the Combine Binaries experience. You can learn more about those enhancements in this article.

This month, we made it easier for customers to access the Combine Binaries feature by allowing them to combine multiple files directly from the folder Data Preview dialog within the Get Data flow, without having to go into the Query Editor.

Note that exposed multiple options (Combine and Combine & Load) allow customers to further refine their data before loading it into the worksheet or Data Model.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor

In the Query Editor, it is possible to see and modify column types by using the Column Type drop-down menu in the preview area.

With this release, we added the Change Type Using Locale option to this drop-down menu (previously available by right-clicking the column header and then selecting Change Type > Using Locale). This option allows you to specify the desired column type and locale to use for the conversion, which affects how text values are recognized and converted to other data types, such as dates, numbers, etc.

New Insert Step After option in the Steps pane inside Query Editor

With this update, we added a new context menu option in the Query Editor window to easily insert new steps in existing queries. The Insert Step After option lets users insert a new custom step right after the currently selected step, which can be the final step or any previous step within the query.

Learn more

Learn more about what’s new in Excel 2016.

Join our Excel community on Facebook and Twitter, and collaborate with others on Get & Transform Data at our new Tech Community forum.

Send us your ideas for other improvements on our Excel UserVoice page.

—The Excel team
Click to expand...

Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs

Windows 10: The excel new web query yellow arrow only on advertisements

The excel new web query yellow arrow only on advertisements

The excel new web query yellow arrow only on advertisements

The excel new web query yellow arrow only on advertisements

The excel new web query yellow arrow only on advertisements - Similar Threads - excel web query

The excel new web query yellow arrow only on advertisements

The excel new web query yellow arrow only on advertisements

www.catalog.update.microsoft.com can not start the download and excel new web query the...

www.catalog.update.microsoft.com can not start the download and excel new web query the...

www.catalog.update.microsoft.com can not start the download and excel new web query the...

Excel Query

Excel Power Query

What is New in Excel for the web

What is New in Excel for the web