+ Reply to Thread
Results 1 to 3 of 3

‘The PivotTable report will not fit on the sheet. Do you want to show as much as poss

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    68

    ‘The PivotTable report will not fit on the sheet. Do you want to show as much as poss

    Since I'm making a PivotTable with my macro, when it runs I always get this...

    ‘The PivotTable report will not fit on the sheet. Do you want to show as much as possible?’

    I always choose yes, because in the end the user isn't going to use all of the data, they will be narrowing it down. Anyway, this comes up a few times througout the macro. Is there something I can put in the code that, if pop up box, always choose yes? Thanks
    Last edited by Tyler_Durden; 08-31-2009 at 09:28 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: ‘The PivotTable report will not fit on the sheet. Do you want to show as much as

    does this help?

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-08-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    68

    Re: ‘The PivotTable report will not fit on the sheet. Do you want to show as much as

    Perfect!! Thanks!

+ 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