Charley Kyd

Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

Some of the specific issues mentioned are addressed as follows:
– Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
- Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
- Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook.
– Links: The behavior of linked workbooks should not be affected by whether the workbooks appear in a single window or multiple windows. If you need to open a separate instance of Excel to avoid updating links, you can still do so by holding ALT when you click the shortcut to start Excel, or by running the command “Excel.exe /x”.
– Closing workbooks: To close all documents and exit Excel, you can either right-click the Excel icon in the task bar and choose “Close all windows”, or you can add the “Exit” command to the quick access toolbar. Then use this button to close all your workbooks with a single click.

For other issues, it would be great to deal with those specifically, either by submitting a separate suggestion here on UserVoice, or by sending feedback within Excel. For example, if there are specific issues with VBA, whether they’re related to SDI or not, please submit that feedback.

If you’d like to find out about the Excel team priorities, please read this post on our TechCommunity – https://techcommunity.microsoft.com/t5/excel-blog/excel-product-team-fy20-goals/ba-p/1342022.

Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

Some of the specific issues mentioned are addressed as follows:
– Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
- Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
- Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

Charley Kyd supported this idea · Jun 9, 2019

Dates prior to 1900

43 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

24 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →

Charley Kyd supported this idea · Mar 3, 2018

An error occurred while saving the comment

Charley Kyd commented · Mar 3, 2018

Negative date-time values currently have no meaning. It would be easy to use those values to cover ALL dates prior to 1900. With the right approach, astronomers, geologists, paleontologists, historians, genealogists, and so on, could use dates prior to 1900. To do so, however, we’d lose the ability to work with the time of day prior to 1900.

The scaling would take some thought to define. The Gregorian dates could go back, perhaps, to Monday, Jan 1, 4713 B.C...the beginning of the Julian calendar. Further back, there’d be a span where only years were tracked. And then centuries, and so on.

This adjusted scaling makes sense, because, for example, the K-T event happened about 65.5 million years ago. But no one will ever be able to say (or want to) that it happened on Tuesday, May 16, 65487 BC at 2:49 am, GMT.

And also, along the way, there's be a function that could convert between Gregorian and Julian dates.

Update Linked Pictures (formerly called the Camera tool)

75 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

21 comments · Excel for Windows (Desktop Application) » Graphics · Flag idea as inappropriate… · Admin →

Charley Kyd shared this idea · Sep 13, 2017

Add a MATCHIFS formula

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

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

An error occurred while saving the comment

Charley Kyd commented · Jun 14, 2017

I agree! If we want to return text from a Table, MATCHIFS would provide an easy way to do it.

I know, there are workarounds. But they shouldn't be needed. Instead, we need MATCHIFS.

Charley Kyd supported this idea · Jun 14, 2017

Chart gridlines on top of series as option

4 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

0 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →

Accepting Votes ·

Scott Ruble (PM MSFT) responded

Thanks for the feedback. This is an interesting idea. We’ll consider this in our future planning. Please continue to vote on this feature idea.

Thanks,
Scott [MSFT]

Charley Kyd supported this idea · May 26, 2016

Add a zoom feature to charts

70 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

13 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →

Accepting Votes ·

Scott Ruble (PM MSFT) responded

This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

Thanks,
Scott [MSFT]

An error occurred while saving the comment

Charley Kyd commented · May 3, 2016

This should be a setting that affects the upper and lower bounds of the chart. That way, as the data changes, the bounds adjust automatically to apply the zoom setting.

Create unique object names by worksheet

3 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

0 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →

Charley Kyd shared this idea · May 3, 2016

save chart as image

31 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

13 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →

Accepting Votes ·

Scott Ruble (PM MSFT) responded

Interesting idea. Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this feature idea.

Thanks,
Scott [MSFT]

An error occurred while saving the comment

Charley Kyd commented · Mar 10, 2016

And also, enhance that feature so we can save the image easily in VBA!!!

My feedback

Add a Split dynamic array function

SUBSTITUTES function supporting arrays of "find" and "replace" parameters

SUMCOLS and SUMROWS functions for Dynamic Arrays

DONT'T CHANGE MY FORMULA!!!!!!!

COUNT.DISTINCT Values

Update Visual Basic for Applications

"Excel found a problem with one or more formula references" - Please tell me where!

Pick color in Excel Like at Powerpoint

Export power query or Table to CSV

Fix Bug in Formula Bar

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

Allow slicers on protected sheets to be USED but not edited

Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

Dates prior to 1900

Update Linked Pictures (formerly called the Camera tool)

Add a MATCHIFS formula

Chart gridlines on top of series as option

Add a zoom feature to charts

Create unique object names by worksheet

save chart as image

Feedback and Knowledge Base

Searching…

Give feedback

Office.com

Your password has been reset