Feedback by UserVoice

# Anonymous

1. ## Workbook level calculation

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the post Charles! And thanx to folks for voting. Much appreciated. We definitely understand the ask and are keeping a close eye on this as it is moving up the vote charts .

Thanx,
Prash [MS XL]

An error occurred while saving the comment
Anonymous commented  ·

Calculation options need to be expanded to include not only active workbook only, but active sheet only as well.

2. ## sumproductif

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
3. ## In CONCATENATE allow a range to be specified, e.g. =CONCATENATE(B14:Z14) instead of current =CONCATENATE(B14,C14,...,Z14)

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
4. ## Ability to reference the end of the column or row regardless of the starting position

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
5. ## Add chmistry data type. at the minimum it should recognize elements.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
6. ## VLOOKUP function for multiple criteria

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

Best,
John [MS XL]

Anonymous supported this idea  ·
7. ## Make a function act as an array function inside a non-array formula.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
8. ## Allow column name to be used in vlookup

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
9. ## Bring back multiple sheets in one excel instance. 2016 is brutal without it.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
An error occurred while saving the comment
Anonymous commented  ·

SDI is a trainwreck. How many macros to link information between workbooks either run poorly or generate errors because recent versions of Excel don't allow multiple open workbooks in the instance?

10. ## MID function - Make the 3rd argument optional

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
11. ## Add a BETWEEN function & operator

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
12. ## Remove The Conditional Formatting But Keep The Format

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous supported this idea  ·
13. ## Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

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. …

Anonymous supported this idea  ·