Why do I have to close some Excel documents twice?

D

DoLu

Certain (but not all) Excel 2003 documents when opened by Excel 2007 in
compatibility mode show ":2" at the end of the document name. Those
documents have to be closed twice before they actually will close. How do we
correct this?
 
B

Bernard Liengme

It is possible to have two views of the same workbook. That is what the :1
and :2 mean
Open a new workbook; use View | Window | New Window then View | Window |
Arrange/tiled to see this effect
To solve your problem; use View | Window | Arrange/tiled and close one of
the views before saving
best wishes
 
D

David Biddulph

You have two windows open on the same workbook. Close one of the windows,
then save the file. Next time you open it, there will be only one window
open.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with SET & REF function 0
Book2 on open; click on X's twice to close Excel 2007? 0
Import data from excel 1
Excel close on startup, but stay in task manager 2
When opening existing doc why do I have to click twice to open? 2
Excel opening MSSynch in 2010? How to stop it? 0
Word & Excel crash when closing (Win7Pro-64, Office2003) 0
Excel plugin for IE7 1

Top