+ Reply to Thread
Results 1 to 4 of 4

File fails to calculate - corrupted?

  1. #1
    Registered User
    Join Date
    08-02-2007
    Posts
    2

    File fails to calculate - corrupted?

    At work I am currently working on a financial model that forecasts a bunch of costs into the future. There is a lot going on in this file, with lookup tables, tons of inputs, a lot of formatting, and all the good stuff, but no massively complicated formulas and very limited use of macros. At around 13000 rows, I noticed that the file was failing to calculate as evidenced by the always present "calculate" in the lower left corner of the screen. So there are a few issues with this model:

    I am not sure if the model is simply to big/complex to calculate all the way through or if it is corrupted somehow. I am nearly positive that the formulas are correct. I have tried taking the first line in the model, which consists of some simple formulas to get dates filled out across the sheet, and pasting it all the way to the bottom of the sheet. This results in the "calculate" error message which is surprising. I would think that excel is designed to be able to take a simple formula and calculate it all the way through the maximum amount of rows it allows, so maybe the file is corrupted. However, when I am working with the original model, other than the "calculate" message, I have to reason to think that the model is failing to calculate as the numbers run and the formulas are working (as far as I can tell). Is it possible that I am getting this "calculate" message but that I have nothing actually going wrong with the file?

    I personally think that the file is fine and that the numbers are probably correct. I just need to be sure for obvious reasons.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Does this link throw more light on your problem?

    http://www.decisionmodels.com/calcsecrets.htm
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    08-02-2007
    Posts
    2
    Yeah, I got the dependencies answer from the MS support guy as well since it was such a large file, but I still think there is something wrong with it. It takes several minutes to calc and I have seen similar size files (even larger) calc in much less time.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    May be this link would be worth reading to

    http://www.ozgrid.com/Excel/ExcelSpr...htm#Formatting

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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