Excel 2013 64bit - Win 7 - Saving ANY VBA code in workbook causes Excel to crash upon reopen!!

[CharBram]

Hey everyone!

Got a bit of a problem that I need help troubleshooting! We have a workbook we use at work which contains various internal data spread across 255 separate tabs. Each of the tabs has about 300 records of data and the file is only about 1MB in size.

The file uses up a lot of memory when I load it and when I went to create a macro that loops through all the tabs I saved the file, thinking everything was good. Later, then i tried to re-open the file it crashes at open and I can't get it to stop.

What are some steps I can take to troubleshoot this?

Error Message Details:

Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 15.0.4693.1000
Application Timestamp: 54b5e407
Fault Module Name: VBE7.DLL
Fault Module Version: 7.1.10.42
Fault Module Timestamp: 523fd3b0
Exception Code: c0000005
Exception Offset: 00000000000ac33a
OS Version: 6.1.7601.2.1.0.256.4
Locale ID: 1033


Additional information about the problem:
LCID: 1033
skulcid: 1033


Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409


If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt

 

[JLGWhiz]

You can try holding down the Shift key while you open the file. That would keep any macros from running. Don't know if that stops the calculation of not. If it is automatically doing a calc, and that is blowing the memory, I am not sure how to fix that.

 

[CharBram]

Thanks! Yeah, it is something to do with opening the file and it just killing my available memory. The spreadsheet takes up about 2.3GB of memory when it is open. I may need to find a way to access the file without opening it. I am going to ask a question related to this in a new thread. Let me know if you have any ideas.