Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I get an error dialog that states "this workbook contains no unbount sheets". It then freezes my session of excel. I cannot find a help topic that relates to this problem. Has anyone seen this before?

This error occurred when I attempted to open a workbook that is dependent upon several others. I have set the workbook up to return values from other workbooks to get a current view of the status of several items as they transition from production to ready-to-ship. There is no VBA coding involved, all the returned values are the results of MATCH or VLOOKUP functions. My workstation computer has only Office 2007 resident, and it none of my colleagues seem to ever have had this error in their collective experience.

To clarify - the dialog box has the message: "workbook has no bound sheets.". The only option is to click "OK" (or to close the box with the red X). Either action freezes that session of Excel.

Thanks for your attention to my plight.

share|improve this question

migrated from Feb 22 '11 at 18:06

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

@warren Your dad will have to register both his SU and SO accounts to regain ownership of this question – random Feb 25 '11 at 16:22

I suggest you to try to save the workbook in an older Excel version (say XP, 2003) and try to reopen it.

share|improve this answer

You must log in to answer this question.