![]() In this situation, you might consider converting your PivotTable to a formula- based report using Excel 2016's new Cube- based functions and conversion tools. In some cases, CPAs find they want to further refine their PivotTable reports using Excel's full complement of editing tools, but their hands are tied by the PivotTable structure. However, once your desired PivotTable is created, you are correct in that your editing options become somewhat restricted. Two key advantages of Excel's PivotTables are that they are easy to create and they provide a structure that can be pivoted to reveal a multitude of report layouts. I usually like Excel PivotTables, but because they don't allow me to do certain things, such as delete cells or insert new columns or rows, I'm wondering if there is a reasonable alternative?Ī.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |