When writing complex formulas, it is very difficult to troubleshoot errors with in-line formats and although I can 'simulate' writing the formula like code in the formula dialog box, it is very cumbersome as it doesn't treat 'enter' as a next line and 'tab' as a tab. Also, when using this format in the current version, selecting a formula part and clicking on the fx doesn't show the values, only blanks. A sample is attached showing the format. Would it be possible to setup the formula dialog box to support a more coding IDE model?

=IFERROR(
SUMIFS(
tblBS[Avg],
tblBS[Month],
[@Month]
)
/COUNTIFS(
tblBS[Month],
[@Month],
tblBS[Avg],">0"
),
"")

When you use the "Index" function it returns a value but it would be very useful to be able to return the format of the cell that is matched too.

So, for example: If I look up a risk in a table (see attached file) then I get the value as "High", "Medium", "Low" and then based on that I have to create a conditional format whereas if the cell that I am referring to already has a format then I could just use it.

A bonus would be changing the colours would only have to be done in one place.

Say you have a function like FIND() that takes a single item to search for. If you have seven items to search for, you have to do them all separately. Yet FIND() cannot be upgraded (aside: for an obviously useful thing) without lots of years of us asking for it here and finally seeing, maybe, something.

The idea here is to have a funciton whose sole purpose is to pass an argument to the function wrapped around it, holding "open" so-to-speak, and after the first argument's pass is over, moving on to do it again with the second argument's value.

Want to compare any of three values against, say, 0 in an IF() with one result if any succeed? Then =IF(LIST(A1,A3,C4)=0,1,5).

It could even allow combination with AND() and OR() so you could specify such for functions where it makes sense (IF(), yes, FIND(), no... well, maybe). So =IF(AND(LIST(A1,A3,C4))=0,1,5) they must all pass, and =IF(OR(LIST(A1,A3,C4))=0,1,5) only one has to pass.

If a value caused an error, like the FIND() example could, it would be ignored if a successful return for one of the other items in the list succeesed, or returned if none did.

The issue with "There's a problem with the clipboard..." while copy and pasting is still as issue. I was using Office 2010 and there was no problem. I am now using Office 365 and this issue is prevalent. It manifests itself when pasting a value from a cell containing a formula and disappears when disabling Live Preview. I was able to copy and paste "normal" cell contents fine before the error message appears so the official response of "another program has locked the clipboard" doesn't really hold up. It looks more like Excel has locked the clipboard from itself.

There is no reason for this issue to have hung around as long as it has and it really should be fixed, especially if Microsoft wan't to keep selling Office as a subscription.

With all the queries on the internet, we assume there is no built-in option to prevent pivot tables from overwriting data beneath the table during refresh and expansion. Is that correct?

Given that Excel has options for 'inserting' rows, why in the world would Microsoft NOT provide a pivot table expansion/contraction option for inserting or deleting rows from within the refreshed table without overwriting data beneath or to the right of the table?

It is also interesting that inserting rows into a regular Excel table, using the TAB key in the last row, can add rows by expanding the table without overwriting the data beneath. Yet, it will fill in any blank rows first before shifting down the data rows beneath the table.

Given the many requests for this option, we are surprised that Microsoft has not responded to this request.

Instead of having worksheet tabs at the bottom of the viewing window, put the worksheet tabs in a column to the far right. This way you can see more tabs on the screen at a time and use longer more descriptive worksheet titles. This would make worksheets much easier to navigate and organize. Furthermore it would be great to make the tabs able to be hierarchical as in the attached example where Schedule 4 has a drop-down arrow that that reveals tabs for sub-schedules a, b and c. Of course please keep all of the fill color options for the tabs. Also allow the user to adjust the column width of the tab column. Would be great to see a worksheet description or comments when hovering over the tab.