Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

We have a workbook that we have been using daily for many years in Excel 2003.

We are now migrating to Excel 2010, and have encountered the following problem.

When the workbook is opened in 2010 (32-bit version on 64-bit Windows 7) (clean open, no other workbooks present) and we try calculating any of the worksheets (even the simplest one), we get the following error:

"Microsoft Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo command."

This does not seem to happen in the 64-bit version of 2010.

If we open the workbook in Excel 2003, there are no calculation issues. If we open the workbook in 2003 and calculate one sheet (shift-F9), or even calculate one cell that is a trivial reference to another cell (=E4), and then save the workbook, we do not get quite the same behaviour: when opened in 2010, we can calculate various sheets (shift-F9 or worksheet.calculate), but when running a macro to calculate all sheets in the workbook, it crashes at some point on one of the sheets. Again, this does not happen in the 64-bit version of 2010.

Has anyone else encountered this problem with Excel 2003-workbooks in Excel 2010, 32-bit version? I cannot find any references to a problem of this description anywhere. Thanks.

share|improve this question

migrated from stackoverflow.com Aug 5 '13 at 18:11

This question came from our site for professional and enthusiast programmers.

    
Is it possible that you have some event macros triggering circular errors? excelforum.com/excel-programming-vba-macros/… –  David Zemens Jul 30 '13 at 16:04
    
No, I wish it were that simple. And that wouldn't be consistent with the observation that calculating one cell in 2003, then saving and opening in 2010 removes many of the problems, nor consistent with the fact that there are no problems in 64-bit version. But thanks for the suggestion. –  David I. McIntosh Jul 30 '13 at 16:37
    
Just FYI this question probably is a better fit for SuperUser.com, it does not seem to be at all programming-related, or, if it is, you have not provided nearly enough information to go on. I'm going to suggest that the moderators migrate it to that environment, where perhaps you will get a better answer. –  David Zemens Jul 30 '13 at 16:46
    
Ah. No, its not really programming related, it seems to be a bug in Excel 2010. I will investigate SuperUser.com. Perhaps I should review the target purpose of StackOverflow and its related sites? Thanks. –  David I. McIntosh Jul 30 '13 at 17:03
1  
While reviewing what is on/off topic might be worth a read of. –  pnuts Jul 30 '13 at 19:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.