Solved

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

Posted on 2016-09-22
6
14 Views
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
0
Comment
Question by:Colmanr123
6 Comments
 
LVL 19
ID: 41811049
it could be that XLSX files are compressed files. Does the same thing happen if an XLS file is previewed?
0
 

Expert Comment

by:parts8
ID: 41811059
Does the blank copy close when a different file is selected to preview?
0
 
LVL 19
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'
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:Colmanr123
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.
0
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 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
0
 
LVL 13

Expert Comment

by:frankhelk
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.

frankhelk
Experts-Exchange Cleanup Volunteer
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
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 will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

760 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

17 Experts available now in Live!

Get 1:1 Help Now