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.

Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
It is more important to us to be able to have each person apply a local filter than to have the rare AGGREGATE function work correctly.
Thanks!

When using Power Query / Get Data to open .xlsx files and .xlsm files, the Tables present in those files are shown in a list.
When opening a .xlsb file only Sheets are shown and not any of the Tables present within the file.

If there is only one table on a sheet, AND it starts in cell A1, then it is relatively easy to still load the data, but where there are multiple tables per sheet, OR the tables don't start in A1, then there is a lot of unnecessary work deleting Rows and or Columns to obtain your data.

Please make the treatment of .xlsb files the same as .xlsx files or provide a new Connector to deal specifically with .xlsb

VBA events are extremely powerful but currently they are seriously lacking! If the Excel team went through and exposed more events VBA would a lot easier to manage for complex applications.

Events to expose:
* Row and column insertion
* Table specific events:
** Table - Insert_Row
** Table - Insert_Column
** Table - Cell_Change
** Table - On Filter
** Table - On Filter button click
* Chart events!
** Chart - On Mouse Down
** Chart - On chart object select
** Chart - On chart resize
* Shape events
** On shape resize
** On shape click
* Comment events
** On Comment Edited
** On Comment Removed
** On Comment Created

And so on. Currently there are extremely few VBA events (a comprehensive list can be found here: https://gist.github.com/sancarn/68003988e83581f09dbbaa85be6611bd#file-original-use-case-md)

Adding more VBA events would greatly advance our productivity, as currently to emulate all the above events we have to poll Excel, which is simply ridiculius...

You open and Excel file and look at it for a moment then click Close. Excel pops up a dialog "Want to save your changes?". I didn't change anything! Please stop asking to save changes when nothing has changed. It confuses the user.

This is made worse if I've has that spreadsheet open for a long time and I don't remember if I changed it or not. Or worse, there may be other people working on the same file and if I say "Save", I overwrite their changes.

I heard that this has to do with Excel saving the current cell position. If all that changed is that, or some other thing that doesn't change the data, maybe the dialog should say "Only current cell position has changed, save it?" Or have a button that says "See what changed" and takes you to a summarized list of what changed. If the only item in the list is "current cell position" I know I can safely click "Don't save".

This is my #1 annoyance with Excel.

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.