+ Reply to Thread
Results 1 to 1 of 1

Pivot Crashing upon adding info?

  1. #1
    Registered User
    Join Date
    07-11-2018
    Location
    Ontario, Canada
    MS-Off Ver
    2016
    Posts
    14

    Pivot Crashing upon adding info?

    I've attached my spreadsheet so you can view what I've done. Essentially I have a summary page (first sheet in the workbook) that summarizes the activities that occur in a 2 week period. Each activity is performed by an employee and lists how many hours they spent performing that particular activity. What you'll notice is that if a particular activity occurs on multiple highways I need separate results, which I've done already. If possible I'd like to be able to add the employee information to the pivot table so I can expand the service order so it lists how many of the total hours were performed by each employee.

    So right now for example, my spreadsheet will say that service order 546 was performed for a total of 40 hours that day. I want a button to expand a list of which employees made up those 40 hours and a breakdown for each. E.g. TOM - 10hrs, JOE 30hrs etc.

    Every time I import that info into excel using ALT D + P it crashes the whole document. Any help would be greatly appreciated.
    Attached Files Attached Files

+ 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. [SOLVED] Xl Crashing: Code to format after Pivot: Show Report Filter Pages.
    By saudi_red_neck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-01-2018, 06:03 AM
  2. Adding multiple images without Excel crashing
    By Jackprendergast in forum Excel General
    Replies: 5
    Last Post: 11-14-2016, 04:25 PM
  3. Need to duplicate a column's info while adding new info and subtracting old
    By kundalinikid in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-09-2015, 06:10 PM
  4. Excel crashing when trying to view code before macro run; not crashing after first run
    By goonerforlyf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 05:27 PM
  5. Pivot Event Keeps crashing
    By niceguy21 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-16-2013, 11:32 AM
  6. Excel macro to get outlook contact info (runtime error/crashing)
    By ZTHawk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2012, 04:19 AM
  7. Spreadsheet with pivot tables keeps crashing
    By Wouterklap in forum Excel General
    Replies: 0
    Last Post: 05-11-2009, 11:35 PM

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