Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Windows Explorer - Print Excel File (Any File Type)

Posted on 2013-01-10
5
Medium Priority
?
304 Views
Last Modified: 2013-01-15
I have a customer that prints files through Windows Explorer on a routine basis.  The process is:

Right Click File (Excel file for this example-cant see that this is issue specific to Excel though)
Print
-->The file then prints and she goes to another file in a different folder and repeats the process

She is pretty quick at it so the process is going rather fast.  The new issue is certain spreadsheets, when she right clicks and chooses print will open the file and ask her if she wants to save the file or not.  She is clicking no and then goes to  the next.  The spreashseet that prompts her to save and the ones that done appear to  be identical.  What would cause one to prompt saving the file and others not to.  

Notes:  Only ten files out of probably a thousand are causing this.  All files are in different folders.
0
Comment
Question by:twomacsfour
5 Comments
 
LVL 39

Expert Comment

by:BillDL
ID: 38766462
What operating system is in use on the computer in question?
What version of MS Office is installed on that computer?

I assume that the user is aware of the various extensions that can be applied to "Excel" files, and would notice if it was one particular extension that was behaving this way?
eg. Templates: xlt, xlthtml, xltm, xltx and the non-template equivalents xls, xlshtml, xlsm, xlsx

Is the user accessing these files from a shared drive, or from her own computer's hard drive?

Has the Read-Only attribute been eliminated from consideration?

My thoughts are that perhaps the handful of files that prompt to save are Excel 2007 and above (xlsx) and are having to be converted when printed through Excel 2003 and earlier, or they are templates.
0
 
LVL 99

Accepted Solution

by:
John Hurst earned 1900 total points
ID: 38766938
Do some of the files have an active date or some similar formula?   I have spreadsheets with =NOW() as a date formula. These worksheets always ask me if I want to save or not, even if I merely open the sheet and do nothing. This has been true forever with Excel.

.... Thinkpads_User
0
 
LVL 46

Expert Comment

by:aikimark
ID: 38773422
If this is the same set of files, have you tried using a batch file to invoke the printing?
0
 

Author Closing Comment

by:twomacsfour
ID: 38780147
At the very bottom in the far right hand corner of the spreadsheet was a cell that updated every the time every second.  

Thanks for your help
0
 
LVL 99

Expert Comment

by:John Hurst
ID: 38780212
@twomacsfour - Thank you and thanks for the update.

.... Thinkpads_User
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

972 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