Results 1 to 2 of 2

Thread: Workbook file size cannot be reduced

  1. #1

    Workbook file size cannot be reduced



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My workbook only contain pivot tables and connect to another external data source.
    The problem is that my workbook file size will become very large once I tired to connect a very large external data source.
    How come the workbook (with pivot table but without data) file size so large?
    How to reduce the file size of the workbook?

  2. #2
    Seeker ekavana186's Avatar
    Join Date
    Mar 2011
    Location
    Richmond, VA
    Posts
    5
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by whoiswct View Post
    My workbook only contain pivot tables and connect to another external data source.
    The problem is that my workbook file size will become very large once I tired to connect a very large external data source.
    How come the workbook (with pivot table but without data) file size so large?
    How to reduce the file size of the workbook?
    Surprising but the entire data set is hidden within your sheet in order to make the pivot table function.

Posting Permissions

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