+ Reply to Thread
Results 1 to 2 of 2

Excel Sheet Compacting?

  1. #1
    Justin
    Guest

    Excel Sheet Compacting?

    Question, is there a way that I can "compact" an excel sheet, just like
    access can be compacted. Reason is that I have this workbook with about
    35worksheets, all pivot tables, I had to change the datasource to sql and now
    the size of the sheet jumped to 500megs (it started off with 100megs). When
    trying to save the sheet, it takes about 5 mins. Also there are about 45
    pivot tables, none of them have the same datasource. was wondering, if
    possible, maybe to save time and space, to change the source to one pivot
    table but still show it as many times as I want.

  2. #2
    Ron de Bruin
    Guest

    Re: Excel Sheet Compacting?

    Hi Justin

    There is no option in Excel but look here
    http://www.contextures.com/xlfaqApp.html#Unused

    --
    Regards Ron De Bruin
    http://www.rondebruin.nl



    "Justin" <[email protected]> wrote in message news:[email protected]...
    > Question, is there a way that I can "compact" an excel sheet, just like
    > access can be compacted. Reason is that I have this workbook with about
    > 35worksheets, all pivot tables, I had to change the datasource to sql and now
    > the size of the sheet jumped to 500megs (it started off with 100megs). When
    > trying to save the sheet, it takes about 5 mins. Also there are about 45
    > pivot tables, none of them have the same datasource. was wondering, if
    > possible, maybe to save time and space, to change the source to one pivot
    > table but still show it as many times as I want.




+ 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