Opening Large Spreadsheets
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Opening Large Spreadsheets

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Some of the traders at our company create huge spreadsheets (40mb to 80mb)with links to other large spreadsheets and then have trouble opening them. Sometimes it can take up to 3-4 minutes for the sheet to open. Can you give me any insight on why this might be happening and how to avoid it in the future.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Some items that cause file bloating and their potential fix:

    1. The *container* becomes corrupt. Copy all sheets to a new file, one by one if necessary.

    2. Contents of cells are deleting, but formatting is still stored. See *Cannot shift...* at: http://www.thewordexpert.com/excel.h...monExcelIssues

    3. They need to break the files up into several files.

    4. They ought to be using Access instead.


    ~Anne Troy

  3. #3
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    951
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I have found that the links between sheets and workbooks slow down the processing speed (I think this is referred to as bottlenecking).

    One way around this continual waiting may be to open excel, go to options and switch Calculations to manual, open up all these spreadsheets you will be using and in theory you can then update the calculations by pressing F9. This may not work for you as the size of the workbooks may prohibit you from opening more than 1 at a time.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com