I was greeted by a spreadsheet that my wife was using that she had messed up. A table than previously showed date, time, address and hours , was now replaced by date, time, formula1, formula2....formula7 as the values in a column and then the duration.
this was solved by going to pivot table Analyse, Fields, items & sets, solve order and deleting the formulas from there. then the addresses reappeared in the pivot table when it was refreshed
So I have no urgent need for a solution, but I am curious if anyone can shed light onto how she could have created this in the first place. she would not be deliberately changing anything, he involvement usually consists of cutting and pasting data to a table and pressing refresh on a pivot table. I suspect some random keystrokes?
Ideally I want to prevent this occurring again in the future, so I do not have to fix it at 2am in the morning! This was office 2016 if that helps
As I fixed the spreadsheet and saved, I do not have a workbook in this state to post (it was late)
Any insight appreciated.
Bookmarks