Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Excel Book1

Posted on 1999-08-10
Medium Priority
Last Modified: 2012-06-27
Problem, When I now open any existing Excel file, the following occurs eg I click on a short cut on my desktop to a file called Quote.xls as example and Excel opens 2 files at once the file I click on plus book1 so infact I have 2 excel files open. ?how do I stop the book1 file from showing
apart from hiding it? I run win98 and Office 200 I have had no hassells in the past 2mths since installing. This only occured last night. I can NOT find any Viruses nor after a complete removal of Office 200o and a new instillation still this anoying new Excel,Book1 file opens with any excel file I click on. Is there some macro hidden or a bug in Excel 2000? Thank you for your help its appreciated!
Question by:ik030197
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 22

Accepted Solution

ture earned 200 total points
ID: 1611256

The probable reason for this is that a file called book1.xls is stored in your xlstart directory, which probably is:
  C:\Program Files\Microsoft Office 2000\Office\XLStart
  C:\Program Files\Microsoft Office\Office\XLStart

If there is a book1.xls file stored there, move it somewhere else. If it doesn't contain anything useful, you can just delete it.

Ture Magnusson
Karlstad, Sweden

Author Comment

ID: 1611257
Thank you, however no book1 in XLstart, after opening a file eg quotes.xls both files (quotes.xls and Boo1.xls) appear on the taskbar with Quotes showing as the active window. if I click on Book1 on the task bar it becomes active and inclosing it it closes both Book1 and quotes, however while both are showing on the task bar if I right click on the Book1 it will close Ok leaving Quotes sheet open and active. If I hide Book1 problem goes however in opening a new Excel sheet, a empty area appears where book1 should appear.
LVL 44

Expert Comment

ID: 1611258
Hi ik, does this happen with any other file you open? Or only with this file? if so >It could be an auto_open macro in the Quotes.xls file, just key the ALT+F11 combi, and look in the VBE for code you did write, modules etc.

Becuase it suddenly happened I think it's a left-over of something....

Let me know,
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

LVL 44

Expert Comment

ID: 1611259
<snip> did "not" write......
LVL 22

Expert Comment

ID: 1611260

Try /regserver. It often solves problems like this.

1. Click the Start button
2. Select 'Run'
3. Enter: c:\program files\microsoft office\office\excel.exe /regserver
   (If your excel.exe is in a different location, you have to change the text above to reflect this)
4. Click 'OK'

LVL 22

Expert Comment

ID: 1953298

Did my suggestion work? Please accept or reject my answer. Or let me know if you need further information.


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

705 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