+ Reply to Thread
Results 1 to 3 of 3

Create Pivot Table in Hidden Sheet

  1. #1
    Forum Contributor
    Join Date
    10-04-2004
    MS-Off Ver
    2013
    Posts
    148

    Create Pivot Table in Hidden Sheet

    Hi!

    I'm getting a 1004 run-time error when creating a pivot table.

    I believe this happens because I'm creating it in a hidden sheet. When I unhide it no errors occur.

    Can anybody tell me if I'm correct? If so, how can I overpass this?

    Thanks in advance!
    Last edited by pmguerra; 03-18-2009 at 07:05 AM.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Create Pivot Table in Hidden Sheet

    Good morning pmguerra
    Quote Originally Posted by pmguerra View Post
    Can anybody tell me if I'm correct? If so, how can I overpass this?
    You will need to unhide the sheet, create your pivot table, and then rehide the sheet again.

    To prevent users from seeing the flicker as these things happen, try disabling the screen updating whilst it occurs :

    Please Login or Register  to view this content.
    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Contributor
    Join Date
    10-04-2004
    MS-Off Ver
    2013
    Posts
    148

    Re: Create Pivot Table in Hidden Sheet

    Ok, thank you!


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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