Tag Archives: Microsoft Office

If you have ever struggled with deleting a PivotTable in Excel, then you have come to the right place. We use Excel for all kinds of things. Once in a while, we like to do a bit of house cleaning. We recently published an article on how to export all of your worksheets within an Excel Workbook to CSV. Well, in order for that to be useful, you can't have a bunch of extraneous information running around your worksheets, like PivotTables.

I recently went on a hunt to try and figure out a way to export all my worksheets in an Excel document to CSV. The need arose simply out of frustration. Instead of copying cells and pasting as values into a new workbook then saving as CSV, I wanted a simple and logical approach that could save me time and frustration.

So, after hitting issues left and right, solving them and posting them on various sites including this one. I had gone dry for a while, there were no issues… I thought to myself “This is too good to be true;” sure enough, it was. However, this is only a minor inconvenience, but one that requires solving none the less.