Excel 2013 opening a blank "copy" of file when preview enabled  in explorer

Posted on 2016-09-22
Medium Priority
Last Modified: 2016-11-04
Excel 2013 opening a blank "copy" of file when preview enabled  in explorer.

If I want to preview an excel file without opening it.  When I highlight the file (single click) it opens excel on my 2nd screen as a blank, and on the top it says the file is "copy of ........" what ever the name of the file I'm previewing.  This is a problem to a client who is experiencing this while giving presentations.
If I disable Preview in Explorer this does not happen.  However the client uses preview on a rewgular basis and finds this Blank excel opening quite annoying.

Thanks for help in advance
Question by:Colmanr123
LVL 24
ID: 41811049
it could be that XLSX files are compressed files. Does the same thing happen if an XLS file is previewed?

Expert Comment

ID: 41811059
Does the blank copy close when a different file is selected to preview?
LVL 24
ID: 41811774
I just installed 2016 (did not happen in 2013 but I had the desktop version installed -- now using O365) and see what you mean about "blank" -- it also appears when I open an Excel file. If I click X in upper right to close the blank, then what I am using wants to close -- and blank stays open! Switch Windows only shows one window. Must be a new 'feature'
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


Author Comment

ID: 41812210
Hi Guys

Crystal I'm not sure about the xlsx versus xls this is something i'd have to check unfortunately I'm only on this site once a week so it will be next Thursday before i'm back.

Part8 Again i'd need to check this onsite but even if it does I still doesn't help with the solution.  The problem is the client is working with Dual screens and he may have one file open on screen 1 then only wants to preview on screen 2.  Then the problem is this blank opens over screen 1.
LVL 24

Accepted Solution

crystal (strive4peace) - Microsoft MVP, Access earned 2000 total points
ID: 41834520
as it turns out, this is related to the Personal macro workbook.  Here is what I did to resolve the blank workbook issue:
1. located the personal macro workbook (mine was in C:\Users\Crystal\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB) so I copied the macros in it to a document so I can put them back later (File, Export would have worked too).
2. I deleted the personal macro workbook
3. modified "default personal templates location" to where I want the personal macro workbook (I just chose the same location).
4. I then opened another workbook and attempted to record a macro to save in the personal workbook.  I got an error message but the personal macro workbook was created again. I then closed Excel and opened the personal macro workbook and closed it.
4. Now Excel opens without the blank and I can also save macros in the personal workbook

this many steps may not be required -- the  point is to replace the personal macro workbook with a later format file
LVL 14

Expert Comment

ID: 41873646
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: crystal (strive4peace) - Microsoft MVP Access (https:#a41834520)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

621 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