Sam49, I have the same problem and I think you describe the situation perfectly. I also do not have any macros recorded since I recently just got the Office 2010 upgrade. It's very annoying to have the Book1 automatically load when I just double click an existing spreadsheet to open.
Even if I use that blank worksheet, book1, to open another file from the menu the original Book1 remains open along with the one I just opened.
I know this thread is a little old, but it describes EXACTLY what I'm experiencing with Excel 2010. I have never created any macros either.
I will say that Word has been exhibiting even stranger behavior when I try to close those files. It states that changes have been made to the global template and do I want to save it, etc. I have to go through about 3 annoying steps when I close out a Word file. In comparison this Excel bug is less annoying so I guess I should count my blessings.
I use Office 2010 at work too, and don't experience these problems, so it probably has something to do with my HP laptop, or how the program is installed, etc. I use Norton anti-virus and have never surfed any suspicious sites with this computer. Besides, the computer isn't exhibiting any odd behavior other than these Office 2010 bugs, so I don't think it's malware causing it.
Quote