One of my least favorite messages that Excel provides is:

"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."

But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.

If Excel finds a problem, please Excel, tell us where it is.

Say you work while traveling on a train. Someone wants to know who you are for whatever reasons. If your name is in the title bar of an application or the user name on the logon screen, giving away your credentials that easily... User credentials should not be disclosed in title bar of office applications and there is really NO sensible reason to show them on the title bar. Fancy true, safe nope. Remove it.

The only way that I know of to see a cell's format category (e.g., General, Number, Date, etc.) is to right-click and hit Format. I would like if there was an option in the status bar called "Cell Format."

Sorry Microsoft, but you really blew it in the 2016 update. Separate Excel windows used to be separate Excel windows. Now they share the same buffers for Undo, copy/paste, and highlighting. This is really limiting when working comparatively on two spreadsheets.

This problem is at least 25 years old: when your local Windows standard has the komma as decimal separator, somehow Excel is too stupid to recognize the point as decimal separator when importing a CSV-file. One look in the CSV and you see that it uses the komma between the columns and the point in the numbers. Hard to believe it when you first see this go wrong and then an old man like me tells you this is how Excel works!!! Please, Microsoft, finish your software.

Without being able to get my Capital One data in Money in Excel I can only get a small fraction of my finances. Either work with a data aggregator that plays nice with Capital One (not Plaid) or allow me to import my data manually.

Change the formula bar for advanced users as well as for beginners. better reading of functions makes work easier for everyone.
Indent the code, view the line (s) where there is an error, quickly see the syntax of a function and a bar that adapts depending on the length of the code that is entered.

There are times when I need to add a column to a pivot table that just shows the value from the field without calculation. For example, part number and part name. I will setup the the pivot table to summarize by part name, but I need the part number to show up in a column, not as a sub-item of the part name in the first column.

To update the stock data type with Indian stock stock exchange rates which will helpful..

I know this has been requested in the past by others. But:
The Financial Market Disclaimer, across the top of the spreadsheet, when using stock data, needs to be removed as it is in the users face. Just have one universal acknowledgment, like the investment banks have, and remove the disclaimer.

Money In Excel - Add Capital One 360 Bank

You may a 100% satisfied with the software working functionality then move beforehand for full model license to maintain the get better or transformed emails. It moreover cut up oversize PST document as much as 5GB and assist MS Outlook versions from 90 seven to 2016. Export OST document to PST is performs works very fast in all state of affairs. The software program is designed with many forms of advanced functions. It is available at sincerely $39. For more information associated with this product,

please go with this net site: https://www.inspiredatacare.com/convert-ost-to-pst.html

Download this Enstella Exchange EDB to PST Recovery Software which is 100% well qualified and talented to do it safely export and convert damaged Exchange EDB file as well as you will proficient to save all recovered Exchange mailbox items into PST Outlook file format with original details. This EDB to PST file conversion utility gives the authority to the user to simply Export EDB items like- emails, contacts, chats, tasks, notes, appointments, and journals to several different file formats such as- PST, EML, MSG, and HTML.

Get freeware to click here-https://www.enstella.com/edb-to-pst-conversion.html

easy shortcut to remove all the filters on tables in a worksheet.

I work in finance and always filtering and unfiltering multiple columns, it would be fantastic and save so much time to have this shortcut.

thank you
Samantha Casey

It would be nice if we could use Python for writing macros rather than VBA. (I realize that it's possible to automate Excel externally using Python and the COM interface, but this is slow.)

Hi Microsoft Excel can you please introduce a feature wherein if more than one tab is hidden it allows us to select more than one tab so we can unhide al required tabs in one go.

Money in Excel should show due dates, statement balance, and minimum owed for debts (e.g. credit cards and loans). Somehow it could track if debts are on "autopay" or paid already for the next due date (or allow the user to specify these).

I would like to be able to call a lambda recursively on the grid without the name manager. a SELF function could refer to the function being written. Is that possible? Here's an example for factorial,

FACTORIAL: LAMBDA(n, IF(n = 0, 1, n * SELF(n - 1)))

Here's another for matrix exponentiation,
MPOW:

LAMBDA( A, p, 

    IFS(

        OR(ROWS(A)!=COLUMNS(A), p!=INT(p),p<0),

            NA(),

        p=0,

            MUNIT(ROWS(A)),

        MOD(p,2),

            MMULT(A,SELF(A,p-1)),

        TRUE,

            LET(

                B, SELF(A,p/2),

                MMULT(B,B)

            )

        )

    )

)