Solved

Excel 2010

Posted on 2013-12-19
3
161 Views
Last Modified: 2014-02-06
Hi

When I open an existing document in Excel 2010 it opens a blank document and my selected document one over the other. If I close the blank document everything is closing.

Is there an option that I can disable to fix this problem?

Thanks
0
Comment
Question by:jpmoreau
3 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 39730446
It appears that Excel is opening the blank in the same "session" as your other one. When you close the blank document, don't click on the red box with the "X". Instead, use File | Close.  You can also try to locate a smaller "X" near the red box and click that to close the current document without closing all docs.

How are you opening the document?  Do you double-click an icon?  Or do you open Excel then use File | Open? or something else?
Different ways have different things that happen so you may want to try other open-type functions to see if the same problem occurs so you can narrow down the source of the problem.
0
 
LVL 7

Accepted Solution

by:
XGIS earned 500 total points
ID: 39730822
Hello jpmoreau... a long shot here but it should not hurt to try this.. in File Explorer click your Documents under Libraries. Goto Properties then click Restore Defaults if it is available.
Alternatively if Win7/8 change your VIEW Preview Pane to Details Pane (Alt-Shift-P).  Then try to reopen the file

Plan B  try a different user profile to test and see if your current profile is corrupted
0
 

Author Comment

by:jpmoreau
ID: 39762922
I will try.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

863 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

27 Experts available now in Live!

Get 1:1 Help Now