Roger Govier

Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

We’ll provide updates as we progress on this feature request.

Thanks!

Ashvini Sharma
Lead Program Manager
Excel

Roger Govier supported this idea · December 18, 2017

Slicers - Remove the selected criteria when a slicer is deleted

14 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

2 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →

Roger Govier supported this idea · December 10, 2017

Pull Current Stock Prices and Historical Data Into Excel

1,013 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

371 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →

started ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded

Hi everyone,
Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

Roger Govier commented · November 18, 2017

Quite agree. This is a much needed feature

Roger Govier supported this idea · November 18, 2017

Get Tables working on protected sheets (add rows, sort, filter, etc.)

874 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

141 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →

Accepting Votes ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded

Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

Thanks

Ashvini Sharma
Lead Program Manager
Excel

Roger Govier commented · October 03, 2016

Just used my last vote on this.
Equally, if there is a Total row in a table, it has to be removed before entering more data else the table will not automatically expand.
I have made the suggestion before to Microsoft to have a switch allowing Totals to be placed above the header row ( a much more logical place as Totals would always be in view), if required, and then table extension would happen automatically.

Roger Govier supported this idea · October 03, 2016

Roger Govier commented · October 03, 2016

I'm out of votes but agree completely with Doug on this.
Equally, if there is a Total row in a table, it has to be removed before entering more data else the table will not automatically expand.
I have made the suggestion before to Microsoft to have a switch allowing Totals to be placed above the header row ( a much more logical place as Totals would always be in view), if require, and then table extension would happen automatically.

Show file name in worksheet, without path name - =FILENAME(). Cell("filename") gives path etc. want only filename

9 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

2 comments · Excel for Mobile Devices, Tablets, Phones (Android, iOS, Windows Mobile) · Flag idea as inappropriate… · Admin →

Roger Govier supported this idea · July 31, 2016

Create a function that returns the list of sheet name(s) in the workbook = SHEETNAME(), =SHEETNAMES()

108 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

17 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →

Roger Govier supported this idea · July 31, 2016

Fix errors and incompleteness in macro recording

23 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

1 comment · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →

Roger Govier supported this idea · June 29, 2016

Build a Pivot Table from the Source Data Sheet

6 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

4 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →

Roger Govier supported this idea · April 15, 2016

Add ability to collapse field areas in PivotTable Field and Area Side by Side view

420 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

9 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →

Accepting Votes ·

Ashvini Sharma (Lead Program Manager, Microsoft) responded

Hi Ken,

Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

thanks
ash [MS XL]

Roger Govier supported this idea · April 14, 2016

Download complete original file from Excel Online

49 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

9 comments · Excel for the web » Collaboration and Sharing · Flag idea as inappropriate… · Admin →

Roger Govier supported this idea · March 14, 2016

Auto Refresh Data for Pivot Tables

21 votes

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

4 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →

Roger Govier commented · February 15, 2016

I have been asking for this to be a switchable option for a long time.
Equally, at the moment, the Pivot Cache is refreshed first, and THEN the refresh of the underlying data source.
This is incorrect.
The Data Source should be refreshed first, and then the Pivot Cache to give the correct result.
Currently you need to do a double Refresh to be sure of having the correct answer.

Roger Govier supported this idea · February 15, 2016

My feedback

Retain text formatting after changing formula references inside shapes/textboxes

Harmonize Excel.CurrentWorkbook with Excel.Workbook

Tables should default to "My table has headers" being ticked

Add Reference R1C1 in the list of commands for the QAT

Intelligent Chart Axis Numberformat Would Eat Decimal Points

Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

Resize Table by double-click

Show Tables in Power Query when opening an xlsb file

Add short month name and short day name in Power Query

Python as an Excel scripting language

Slicers - Remove the selected criteria when a slicer is deleted

Pull Current Stock Prices and Historical Data Into Excel

Get Tables working on protected sheets (add rows, sort, filter, etc.)

Show file name in worksheet, without path name - =FILENAME(). Cell("filename") gives path etc. want only filename

Create a function that returns the list of sheet name(s) in the workbook = SHEETNAME(), =SHEETNAMES()

Fix errors and incompleteness in macro recording

Build a Pivot Table from the Source Data Sheet

Add ability to collapse field areas in PivotTable Field and Area Side by Side view

Download complete original file from Excel Online

Auto Refresh Data for Pivot Tables

Feedback and Knowledge Base

Searching…

Give feedback

Office.com

Your password has been reset