Hey not sure if this helps but one thing I have noticed is that if I have not saved the file to a drive, local or server, then I get this error message. I am downloading the file, working on it and forgetting to save before attempting to insert the pivot table. I even tried the above step and the only reason it helped me is because I had to save first... Thanks