December 8, 2017
My name is Mitul Parikh.
Earlier today, I was working on Excel 2016 Pivot Tables exercises from 1 book I purchased. I was trying to figure out how to eliminate Tax bar
(from Pivot Chart) that I created by clicking on Recommennded charts. All of a sudden, Excel stopped working , then, I went backstage, clicked
on File, options, save, there I noticed that Autorecover file location box : there is C:\Users\Mike\AppData\Roaming\Microsoft\Excel\ (Mike is my
merican name), clicked on Users folder, then, name, AppData, Roaming, Microsoft, Excel, but file which I was working on is not there. Can
anybody please help me, is there any way to recover that big workbook of Pivot Tables ?
Also, is there any way , someone can help me if there is any way we can eliminate 1 field which is in Pivot Table (in this case, Tax) from Pivot
Thank you very much. Have a great day.
April 21, 2015
I think the purpose of the Forum is that one askes his/her questions and somebody else tries to help with an answer. By doing this in the open (on the Forum self), everybody who is interested can learn from it. So I prefer not to e-mail an answer, but answer you here.
As far as I know or have experienced, the recovery file only is available when you save in between some times. The standard saving time is 10 minutes and I always advice people to bring that back to 1 minute if the file you are working on is not too complicated or big. And maybe there is another setting, not sure, you must have 'on' to be able to use recovery files.
Anyway when starting after such a brute crash doesn't have a message from Excel that there is a recovery file, means that it didn't save anything for you I'm afraid. So I think there is nothing for you left then work again on this sheet. But with more savings in between times, automatic and by hand (CTRL+S, make a habit of it).
Oh and the question of eleminating a field of a Pivot Table is easier to answer with an example. In general: you can place and not place every field in a Pivot table, you don't have to use them all! So just uncheck the not wanted field from the list on the right (which you see when you have an active cell in the pivot table itself)