Sunday, March 27, 2016

Troubleshoot:144MB Excel file will not open

144MB Excel file will not open

I am using Excel 2007 on XP.  I have a large Excel file (144MB) that will not open.  The file contains Pivot Tables and macros that perform calculations on a temp sheet.  The data is cleared when i close the file normally and the file size stays around 30MB. 
Once in a while I will process a large amount of data that will temporarily increase the file size to ~140MB.  When I attempt to close the file I sometimes get the "cannot perform with available resources" message and am unable to clear out the data before
closing.  When this happens the file size gets stuck at the 140MB instead of clearing out the data and reducing the size.  I am then unable to open the file.  I learned the hard way and started setting backups for my files but it is still frustrating to lose
changes.  When I attempt to open the file I watch the task manager to see the memory resources that Excel is using.  It seems that Excel hits a limit and then gives up trying and will try to recover.  I have read on other sites that Excel has a 2GB memory
ceiling.  Is this true?  I also read other responses that recommend reduces the resources used by other programs.  I have tried clearing out my startup programs using MSCONFIG, have defragged, have tried repair and open, have closed all other programs but
nothing seems to work.  Is there a trick to getting large files to open or to slow down the resources that Excel uses to allow it time to open the file?  Is there another way to open the file so I can clear out the data manually and then resave?
Thanks

Anwsers to the Problem 144MB Excel file will not open

Download SmartPCFixer to Fix It (Free)

I can understand the problem you're facing.
Let me try to answer your question in 2 steps:

1) Recovering current file 
- Try closing all application that aren't needed at all

- Open excel in safe mode
   Start > Run > Type > Excel /s
   Try opening the 144 mb file

- Avoid running any macros on start up, if macros are enabled by default disable first
  Office button > Excel Options > Trust Center > Trust center settings > Macro settings > Disable all macros with notification

- Clear data in parts and keep saving file in between

If the file doesn't open try opening on a PC which are bigger RAM and Hard disk (colleagues/friends pc/laptop?)

2) Future Maintenance
First avoid writing temp information in same file itself.
You can write temp information in external file (excel or a text file) and then delete it after use. This will avoid problem relating to original file getting disturbed.

Secondly I am not sure about the logic going around in your file but if you can think of ways to write minimum temp information, write in parts/phases, etc.
then it will avoid much of the hassles.

Excel tries to use maximum available memory, once it reaches the system limit or its own limit, it hangs or stops.
Lot of times memory is used for UNDO purpose, if you close and reopen file the memory usage will be reduced as UNDO information is deleted.

So the trick is to make your program efficient and build the system which is thought around excel limitations.

I sometimes use applications like MSDos, Textpad, etc.
for memory eating processes where excel won't be efficient, you may explore such option as well.

Because of this 144MB Excel file will not open error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error 144MB Excel file will not open can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve 144MB Excel file will not open error or repair the corrupted and damaged Windows files, you will need a 144MB Excel file will not open error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

  1. Start the computer and log in as administrator
  2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
  3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
  4. On the new confirmation window that appears, click Next
  5. Restart your computer after the restoration has been completed

Another Safe way to Repair the Problem: 144MB Excel file will not open:

How to Fix 144MB Excel file will not open with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related:
Read More: 2007 Access table moved to sharepoint 2005 became read only. how to fix? [Anwsered],1601 error from MSI.DLL 4.5 when trying to install programs.,Troubleshooter of Error: 2.7 out of 3.00 installed RAM "usable"?,How to Fix Error - 3 general questions?,[Anwsered] 2007 install on windows 8,2 available drives on protection settings RECOVERY and OS (C) System and restore points,2 systemic problems in Win 7,2have a new i phone 4 s 32bit, downloaded i tunes but it alway's say's not connected to internet, using HP G62-220CA notebook,32 bit Windows 8.1 but with 64 bit processor,5.24.13 - Using word and vista. Suddenly Word now copies and pastes html code instead of the web page content. help

No comments:

Post a Comment