When in Page Layout mode, have the option to zoom out on one page. Word has a "One Page" option in the zoom settings. Excel is default to "Multiple Pages" when zooming out and scrolling. Would be nice to see how the document will appear printed out.

See attached for what is available in Word.

Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.

Fix this ridiculous problem: "Sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist."

Please bring back MDI for Excel. SDI is really slow, and crashes when I run the apps I've developed over my career that rely on multiple workbooks loaded simultaneously. Or re release 2010 and just call it the version for the folks who rely on MDI and there are a lot of us!!!!!!

I would like to have the possibility to select a PivotTable by name.

In a PivotTable chart, the source tells you what is the PivotTable name but then, you have so select all your PivotTables one by one to find the correct PivotTable.
So if you can add a tool that is able to select a PivotTable by name, it will save a lot of time.

Thanks

I'm frequently using saved files as templates. With the new AutoSave function my old files get overwritten as soon as I start editing the file. I have to save the new one immediately with another name otherwise I'll loose the old one. This is annoying.
Pleas allow to deactivate AutoSave function in the Option settings.

Idea:
Excel might have a built-in function for generating random values.
Two 1-dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
E.g. ["apple","orange","apricot"] [10,20,30] -> 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".

Rationale:
-This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
-The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).

Hi All,

I import data using Power Query from multiple resources and Lots of time I have seen in Power Query that even though we click on Refresh All still not all tables refreshes the data in Power Query Editor.

So I am looking for feature of option in Power Query that shows last data import date. So that user easily know if all the resources have been updated or not or when it last refreshed ?

It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

I work with lots of lines and its tireing to try and track which row im on,
Please try and Highlight the active row.

Give users the ability to put the color back in all the Toolbar icons. The October 2018 white/blue icons are impossible to decipher. Huge step backwards.

By adding Word's "Change Case" options to Excel it would improve Excel's editing abilities and increase customer productivity adding value to the Excel product

Idea of insertion/ removal of Watermark in the excel sheet like in word is likely for some creative work

Allow the VLOOKUP formula to recognise a column label in place of the column count. This is a sorely lacking functionality when referencing large data sets that can easily extend to column counts of 50 or more.

Example: =VLOOKUP(A2,F:AM,AM,false) instead of =VLOOKUP(A2,F:AM,34,false)

Hi All,

I tried to use Active directory feature of Power Query but still not able to find any solution in any forum to speed up the downloading data.

I have more than ~300,000 records to import (i.e. Distribution list contains each member list) from Active directory but it takes 12-~14 hrs to import using Power Query.

Can we look into this feature why there is so much time taken by Power Query and How we optimize the same ?

Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
This would make possible to use variable contents.

Thanks,
Fernando Fernandes

The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.