Hi, there
At source Data table, In case of large data set, If a user decide or visualise and select which fields should be used to generate pivot table + the result of that field !! - Currently there is no option, I suggest to have this tab to be added at source database filter itself, At Advance Tab named as "Advance PT Source Field Chooser" further Pivot should use only those field as source to generate Report Result, which will reduce the file size or provide Expand,Collapse result, each selected field should be displayed with column Serial no and original Description and Caption "Change description" Awaiting on your feedback ,thank you in advance

Please identify WHICH pivot table is causing the problem. when you have a spreadsheet with many many pivots on many tables, this error means that you have to manually search each pivot table until you find the one (or more) that is causing the problem. in fact, because pivot tables based on tables can get messed up if you delete table columns, even if you figure out which data set is causing the problem, you still have to manually adjust (change data) for each one of the pivots based on the table. Excel should adjust the data range on pivots based on tables in the same way it does for ordinary data ranges. And it should provide a more informative error message. even if it only listed the name of the first pivot table that it hits with this error, that would be a help.

We have a corruption on a specific Excel file. This corruption very significantly reduced Excel performances. Unfortunately, Excel did not automatically detect the corruption while opening the file. We have to manually remove "custom views" for the Excel file, and re-open it to allow Excel detecting the corruption and repairing it. It is a pity that Excel cannot detect the corruption by himself, if we did not perform the trick of removing custom views. I am reproducing the issue with last version of Excel.
My request is to improve the corruption detection, so this kind of corruption can be detected. I can share a "impacted" file sample upon request.

There needs to be a huge update regarding the Evaluate Formula.
I'm sure those using this feature are not trying to see simple calculations done.

For me, I might create a report that has a cell calculate multiple IFs within IFs that have embedded functions.

with this in mind, it would be a huge advantage to the user if the Evaluate Formula has the following upgrades:

1. able to expand the window.
the window currently is too small and only allows to view simple calculations.

2. color code what is being calculated.
with everything being the same color it is a bit difficult to see what changes are happening in the calculations if the calculation is complex. underlining, bolding and italicizing seem a bit archaic.

3. allow to reverse the steps.
sometimes if clicking Evaluate many times, over-clicking it might occur, missing a change the user wants to see. it becomes tirelessly time consuming if the user has to redo the evaluation from the beginning.

4. behavior when dealing with arrays.
this is in reference to the Evaluate Formula expanding an array. if the array is long, it is sometimes pointless to see all the values it has. There should be an option in the window to allow the arrays to expand or to suppress it.

5. eliminate spaces in the window
if a calculation is long, sometime it is necessary to write it out using multiple lines ([alt + enter] and indenting). when going to the Evaluate Formula, these spaces are included when it serves no purposes for readability in the Evaluate window.

6. do not have the Evaluate Formula formatted as prose
again, if the calculation is complex, there is an issue of readability when seeing the steps. having the evaluation as one long line of wrapped text can be hard to digest

most of these points have been requested already and they are all pretty much asking the same thing: make the Evaluate Formula more readable and account for any evaluations they may not be important to the calculation.