LinkBack URL
About LinkBacks
My workbook took my 3 three years to build. The current copy has become corrupt. Although I have previous copies that are okay, I would like to know if there is a way to recover from this given that i would, otherwise, lose about 4 days of work.
Corrupt Workbook
My workbook took my 3 three years to build. The current copy has become corrupt. Although I have previous copies that are okay, I would like to know if there is a way to recover from this given that i would, otherwise, lose about 4 days of work.
Last edited by SDruley; 10-05-2009 at 08:33 AM.
Maybe one of these suggestions: http://www.socrtwo.info/excel.htm
Entia non sunt multiplicanda sine necessitate
Sometimes you can open corrupt Excel files with OpenOffice.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you gentlemen. I'm not sure that my workbook is corrupt. I can open it, save it but when I try to calculate the workbook is gives me a "ran out of physical assets" to calculate. When I try to calculate the worksheet it is okay. The workbook takes 6 minutes to open. Am I over the limit?
How big is the workbook? How many array formulas -- how long does it take to calculate?
Is there any code, excessive formatting? Delete all unused rows and columns.
Or copy all sheets to a new workbook and save.
The workbook is 233MB and is one of five engines of similar size. It has 13 worksheets.
It used to take 20 seconds to calculate this particular engine, now it will not calculate the workbook due to resources issues. The worksheet will calculate in 3 minutes.
I deleted all of the rows and columns that are not being used. I have stayed away from formatting. There are about 300 lines of code in this module while the other four engines contain about 1000 lines of code each. I have partitioned the workset into five engines for various reasons, one of which is to eliminate resource loading.
No array formulas are being used.
Each equation has an average of 350 characters and represents a very complex array of mathematical techniques, some of which are not yet in textbooks.
Do you think that the next step is to move (copy) each worksheet into a new workbook?
Download CodeCleaner by AppsPro (Google for) and run it. It is written by Excel gods, and can reduce workbook size significantly. I'll explain how it works if you're curious; it's pretty simple
Does the amount of data in the workbook justify the file size, in your mind?
Re: Corrupt Workbook
shg, I will try the code cleaner tomorrow. In the meantime the 5 engines are wrapped around 5 world-wide financial indices. The data goes back to 1897. The software can predict tomorrow's DOW to within +/- 0.6%. I believe the file size is commensurate with the task.
Would I be better served by further partitioning of the task, perhaps into 6 or 7 engines instead of 5?
I have observed your expertise across the forum and it is impeccable.
Your support is greatly appreciated. Also, the new web site is outstanding.
Steve
New web site?Also, the new web site is outstanding.
I don't have a mental model of 'engines' and 'data'. You could (perhaps appropriately, i dunno) put the code in an add-in, the source data in a separate workbook, and the prescient results in a third.
I don't grok what occupies 1/2 GB of space.
Last edited by shg; 09-25-2009 at 12:24 AM.
Re: Corrupt Workbook
Sorry, I thought the "Excel Forum" web site looked different.
I made a copy of the workbook, took all of the code out, and it still will not calculate. The specific error message reads:
"Excel ran out of memory while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."It would be interesting to determine what formulas gave Excel trouble. One hypothesis would be that a specific formula causes the normal calculation cascade to fail as opposed to the memory overrun.
Is there a way to find out what formulas are interfering with the calculation mechanism?
I will continue to whitle down the workbook as a means to ruling out the size and complexity of the workbook as the root cause for calculation issues.
Steve Druley
I don't know of a way other than by stripping out formulas from the end of the calculation chain toward the beginning.It would be interesting to determine what formulas gave Excel trouble.
You might look at http://www.decisionmodels.com/fastexcel.htm, and at the Excel pages on calculation, speed, and memory at the same site.
Originally Posted by shg
DATA occupies space -- code not so much, but module sizes should be less than 64K. Have you tried exporting the modules to .bas files and looking at their sizes?
I still can't get my brain around a 500MB file, unless it is indeed a ton of data.
And do run CodeCleaner on a COPY of your workbook. I have never had a problem with it, but you never know.
I copied all of the worksheets (as a grooup) into a clean, new workbook. now everything is back to normal. Thanks so much for your help.
Solved? If so, please mark the thread, Steve.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks