Roger Govier

← Welcome to Excel’s Suggestion Box!

My feedback

Retain text formatting after changing formula references inside shapes/textboxes
13 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Dec 19, 2018
Harmonize Excel.CurrentWorkbook with Excel.Workbook
37 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
3 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Dec 3, 2018
Tables should default to "My table has headers" being ticked
- Table Header.PNG 15 KB
46 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
6 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Nov 14, 2018
Add Reference R1C1 in the list of commands for the QAT
8 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
2 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Nov 4, 2018

Roger Govier commented · Nov 4, 2018

Great idea
Intelligent Chart Axis Numberformat Would Eat Decimal Points
15 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
4 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Sep 17, 2018
Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot
- Reporting_Ribbon.PNG 48 KB
143 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
16 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · May 2, 2018
Resize Table by double-click
12 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
0 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Apr 19, 2018
Show Tables in Power Query when opening an xlsb file
43 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
11 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier shared this idea · Apr 13, 2018
Add short month name and short day name in Power Query
29 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
1 comment · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Mar 6, 2018
Python as an Excel scripting language
5,840 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
400 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Delete… · Admin →

Accepting Votes · AdminExcel Team [MSFT] (Admin, Office.com) responded

Wow.

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 · Dec 18, 2017
Slicers - Remove the selected criteria when a slicer is deleted
13 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
2 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Dec 10, 2017
Pull Current Stock Prices and Historical Data Into Excel
916 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
325 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Delete… · Admin →

started · AdminExcel Team [MSFT] (Admin, 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 access historical quote data is a work in progress, and I will update this audience once the feature begins its rollout to Office Insiders.

Feel free to leave comments and requests below, or by sending feedback directly from Excel by clicking the Smiley face in the top right corner, or going to Help > Feedback in the ribbon.

James Spotanski (Excel)

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 · Nov 18, 2017

Quite agree. This is a much needed feature

Roger Govier supported this idea · Nov 18, 2017
Get Tables working on protected sheets (add rows, sort, filter, etc.)
669 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
105 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Delete… · Admin →

Accepting Votes · AdminExcel Team [MSFT] (Admin, 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 · Oct 3, 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 · Oct 3, 2016

Roger Govier commented · Oct 3, 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
8 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

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… · Delete… · Admin →

Roger Govier supported this idea · Jul 31, 2016
Create a function that returns the list of sheet name(s) in the workbook = SHEETNAME(), =SHEETNAMES()
100 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
17 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Jul 31, 2016
Fix errors and incompleteness in macro recording
20 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
1 comment · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Jun 29, 2016
Build a Pivot Table from the Source Data Sheet
6 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
3 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Apr 15, 2016
Add ability to collapse field areas in PivotTable Field and Area Side by Side view
375 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
8 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Delete… · 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 · Apr 14, 2016
Download complete original file from Excel Online
45 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
9 comments · Excel Online » Collaboration and Sharing · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier supported this idea · Mar 14, 2016
Auto Refresh Data for Pivot Tables
16 votes
Sign in
prestine

Your name

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea
4 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Delete… · Admin →

Roger Govier commented · Feb 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 · Feb 15, 2016

← Previous 1 2 Next →

Roger Govier

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