Workbook created in 2003 crashes Excel when you try to  open it in 2007

Posted on 2011-02-17
Last Modified: 2012-05-11
Please open "BombsIn2007ErrorMessages.xls" to get an idea of what's happening, and then open "BomsbIn2007.xls" and let me know what might be causing this and how to fix it. They want this yesterday so I'll be deeply grateful if you can solve it for me. :-) MAKE SURE YOU HAVE EVERYTHING OPEN IN EXCEL SAVED!!

Question by:gabrielPennyback
  • 3
  • 2

Accepted Solution

KnutsonBM earned 250 total points
ID: 34922883
It is not 'Sumif' that it is saying is a problem, it is 'Sumifs' which you can put in multiple criteria.  It appears in Module 3 there is a Sub named sumifs, this will conflict with the pre-defined formula in xl2007 (which is extremely useful).... if you rename that it should clear the problem.

Since it has macro's in it (the most i've ever seen in one workbook), you have to save it in xl2007 as a .xlsm (macro enabled workbook) which is a choice in the drop down when you do a 'save as'



Author Comment

ID: 34923115
Hi Brandon, thanks for noticing that. I keep meaning to delete all the macros I'm not using but I never seem to get around to it. Is there a way to determine for sure what macros are not being used?

Anyway, I still get the message telling me "A formula in a cell (Name:[BAW 2011 Week 06.xls]All Incidents!zyzClick) could not …" and I can't find that name in Name Manager. There was a macro by that name but I've deleted it. Any thoughts?

LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 250 total points
ID: 34924497
Open your file in 2003, open the VBE, then choose Debug-Compile project, fix the error that appears and keep doing that until there are no more errors. You should NEVER use a workbook that won't even compile in production. ;)
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.


Author Comment

ID: 34930269
Hi Rory, you'd think by now I would have already known how important it is to debug, thanks for the "reminder."

After debugging, I got it to where I could save it in 2003 as 2007.xlsm, but it still crashed when my co-worker tried to open it in 2007. And I still get the message about 'sumif' even though I renamed that macro.

Did you open it in 2007?

- John
LVL 85

Expert Comment

by:Rory Archibald
ID: 34936181
Can you post the debugged version for testing?

Author Closing Comment

ID: 35063462
Thanks for your help, I found a workaround.


Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now