+ Reply to Thread
Results 1 to 2 of 2

Power Pivot Excel Crash When Saving New Workbook From Pivot Data

  1. #1
    Registered User
    Join Date
    09-25-2020
    Location
    Louisville
    MS-Off Ver
    365 Pro
    Posts
    29

    Power Pivot Excel Crash When Saving New Workbook From Pivot Data

    I am currently experiencing a strange issue and thus far have been unable to find any similar cases on the internet. I typically work with my data models through power pivot to have access to some of the more robust functionality, however, me and my coworkers have begun to experience a crash in these files. It only occurs when data drillthrough is performed on a pivot table, the new sheet is moved out of the original workbook, and then an attempt is made to save that sheet somewhere else. Has anyone experienced something like this or know how to resolve it?

    It's not a huge issue as we can simply copy the resulting drillthrough tables to a new workbook manually, I would mostly just like to know why it's happening and if there was any way around it.
    Last edited by Beefhamburger; 05-20-2022 at 03:49 PM. Reason: Additional Comments

  2. #2
    Registered User
    Join Date
    03-27-2024
    Location
    Brown Deer, Wisconsin
    MS-Off Ver
    Version 2401 (Build 17231.20290)
    Posts
    1

    Re: Power Pivot Excel Crash When Saving New Workbook From Pivot Data

    I have the same issue although I'm not using Power Pivot - just the regular Pivot Table functionality. I'm on Excel version 2401 (Build 17231.20290) and just did an office repair (this did NOT resolve the problem). Sometimes the crash will occur upon drilldown for the detail as the worksheet is created. Sometimes the crash will happen as the new worksheet is being moved to a new workbook. However, Excel consistently crashes as the attempt is made to save the resulting worksheet as a new workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power pivot data with multi-sheet workbook?
    By NebulousCreatures in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2021, 05:01 AM
  2. [SOLVED] Power pivot or pivot table for connecting data and creating calculated fields
    By jaryszek in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-06-2019, 08:31 AM
  3. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  4. Replies: 2
    Last Post: 05-14-2017, 01:40 PM
  5. Replies: 0
    Last Post: 10-20-2016, 11:52 AM
  6. [SOLVED] Question on Updating my Pivot Tables and Power Pivot in my workbook
    By rv02 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2015, 06:08 PM
  7. Power Pivot with multiple pivot charts using different pivot data
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2013, 10:18 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1