+ Reply to Thread
Results 1 to 1 of 1

help me in reducing ram usage of excel file

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    koera
    MS-Off Ver
    Excel 2010
    Posts
    1

    help me in reducing ram usage of excel file

    i have a .xlsb excel file sizes 1.4mb,
    when i open it, it takes 1.9 GB of ram.
    so i found solution that switching forcefullcalculation to true, and it worked.
    after switching, it only consumed about 20mb of ram. (200? it dosen't matter)
    so i saved the file and when i reopened it(after exiting excel), the amount of memory consumed was 1.9GB again..
    and i checked the workbook attribute forcefullcalculation, it was true.
    I manipulated it in 2 ways
    1. i switched it to false, memory was same 1.9GB and switched to true again, became 20(200?) mb..
    2. i set it to true again, memory became 20(200?)mb again.

    i don't know why forcefullcalculation attr do not work when opening excel file.

    plz someone help me i can send you my file.
    Last edited by rkdrnf; 10-25-2012 at 08:00 AM. Reason: help me with..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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